Microsoft Azure PlayFab logo
    • Multiplayer
    • LiveOps
    • Data & Analytics
    • Add-ons
    • For Any Role

      • Engineer
      • Designer
      • Executive
      • Marketer
    • For Any Stage

      • Build
      • Improve
      • Grow
    • For Any Size

      • Solo
      • Indie
      • AAA
  • Runs on PlayFab
  • Pricing
    • Blog
    • Forums
    • Contact us
  • Sign up
  • Sign in
  • Ask a question
  • Spaces
    • PlayStream
    • Feature Requests
    • Add-on Marketplace
    • Bugs
    • API and SDK Questions
    • General Discussion
    • LiveOps
    • Topics
    • Questions
    • Articles
    • Ideas
    • Users
    • Badges
  • Home /
  • General Discussion /
avatar image
Question by Anand Lal · Dec 01, 2020 at 02:13 AM · datasupport

Bad request error and 400 error code with Power Bi.

Using Power Bi to log into https://insights.playfab.com but when I use the Desktop version of Power Bi, I receive a Bad Request error message. When I use the web application of Power Bi to refresh an existing report, I receive a 400 error code.

I use AAD login method and go through the login flow, but still receive the 400 error code.

When I open the Desktop version of Power BI to manually refresh each query, some queries will refresh, but some will hit a 429 error code "Too Many Requests".

Comment

People who like this

0 Show 3
10 |1200 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users
avatar image SethDu ♦ · Dec 01, 2020 at 05:24 AM 0
Share

Have you followed the instructions on Connecting Power BI to Insights - PlayFab | Microsoft Docs to connect to Power BI? Do you have any other specific error messages when opening https://insights.playfab.com?

avatar image Anand Lal SethDu ♦ · Dec 01, 2020 at 05:27 AM 0
Share

Yes, I was able to get it connected using the Power Bi Desktop version. But when I publish the report in the Power Bi web app, I have to validate my user credentials. I try to validate the user credentials with OAuth2 method, but still get a 400 error code in the Power Bi web app.

avatar image SethDu ♦ Anand Lal · Dec 01, 2020 at 08:39 AM 1
Share

I will try to reproduce this issue.

3 Replies

· Add your reply
  • Sort: 
avatar image
Best Answer

Answer by Anand Lal · Dec 09, 2020 at 06:24 PM

The proper permissions are set and I am using the same email for both PowerBi & PlayFab. One thing I'm wondering is if someone else creates the report using their AAD. Then that person sends me the report to add my additions, will the report fail to refresh because the initial connection was done by someone else? Leaving me with a "Bad Request" error message

In PowerBi, I can create a new table by clicking "New Source" selecting the Azure Data Explorer, and inputting the necessary details to connect to PlayFab and connect perfectly fine. I believe the issue lies when I'm refreshing a table created by someone else who used their credentials to make the initial connection.

Comment

People who like this

0 Show 1 · Share
10 |1200 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users
avatar image SethDu ♦ · Dec 10, 2020 at 07:18 AM 0
Share

I am not sure of the certain behavior of PowerBI as I am not expert on it. For now, please follow the instructions on Connecting Power BI to Insights - PlayFab | Microsoft Docs.

avatar image

Answer by SethDu · Dec 03, 2020 at 01:54 AM

I cannot reproduce this issue. I am using Microsoft AAD (Azure Active Directory) for login, there is no issue on both Desktop version and Web page.

Since your Desktop version is able to connect to https://insights.playfab.com, I don’t think there is any other things PlayFab can do because PlayFab is just the data source, the rest of the actions is Azure and PowerBI behavior. I have published my project via desktop app to PowerBI workspace and it works fine for me.

I believe you may consult Azure or PowerBI support for the authentication issue.

Comment
Anand Lal

People who like this

1 Show 1 · Share
10 |1200 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users
avatar image Anand Lal · Dec 03, 2020 at 03:22 PM 0
Share

Thank you for trying! Now the desktop version is giving me a Bad Authenication Error message. I did submit a ticket to PowerBi support so I'm waiting on a response. I can access PlayFab online so not sure where the disconnect is happening. I can leave an update once it's been resolved.

avatar image

Answer by Anand Lal · Dec 09, 2020 at 02:07 AM

Hello @SethDu

PowerBI support has come back to me with a Bad Request error saying my credentials are the issue. But I can access PlayFab online through a web browser (developer page). I cannot access it through PowerBi. Is there a computer setting that could be interfering with my login flow through PowerBi?

Comment

People who like this

0 Show 1 · Share
10 |1200 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users
avatar image SethDu ♦ · Dec 09, 2020 at 05:47 AM 0
Share

Would you navigate to the studio management page and click the right top ellipsis button? Then enter the "Users" page.

  • Make sure your login account in PowerBI is listed and its authentication method is using "AAD". The same email account but with PlayFab authentication won't work.
  • This account is the Admin of this studio. If it is just Member, you may grant the permissions from the Administrator.

Your answer

Hint: You can notify a user about this post by typing @username

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Navigation

Spaces
  • General Discussion
  • API and SDK Questions
  • Feature Requests
  • PlayStream
  • Bugs
  • Add-on Marketplace
  • LiveOps
  • Follow this Question

    Answers Answers and Comments

    2 People are following this question.

    avatar image avatar image

    Related Questions

    Playfab Website, Server Performance Issues 1 Answer

    Representing relational data in Title Data,How to represent relational data in Title Data 1 Answer

    We need to store data for a turn based game, that data is about like 5kb because are long turns. 1 Answer

    Custom Data size for Store/Catalog/Inventory is way to small 1 Answer

    Save and Load player location or other data in UE4 Blueprints? 1 Answer

    PlayFab

    • Multiplayer
    • LiveOps
    • Data & Analytics
    • Runs on PlayFab
    • Pricing

    Solutions

    • For Any Role

      • Engineer
      • Designer
      • Executive
      • Marketer
    • For Any Stage

      • Build
      • Improve
      • Grow
    • For Any Size

      • Solo
      • Indie
      • AAA

    Engineers

    • Documentation
    • Quickstarts
    • API Reference
    • SDKs
    • Usage Limits

    Resources

    • Forums
    • Contact us
    • Blog
    • Service Health
    • Terms of Service
    • Attribution

    Follow us

    • Facebook
    • Twitter
    • LinkedIn
    • YouTube
    • Sitemap
    • Contact Microsoft
    • Privacy & cookies
    • Terms of use
    • Trademarks
    • Safety & eco
    • About our ads
    • © Microsoft 2020
    • Anonymous
    • Sign in
    • Create
    • Ask a question
    • Create an article
    • Post an idea
    • Spaces
    • PlayStream
    • Feature Requests
    • Add-on Marketplace
    • Bugs
    • API and SDK Questions
    • General Discussion
    • LiveOps
    • Explore
    • Topics
    • Questions
    • Articles
    • Ideas
    • Users
    • Badges