I am using Office 365 ProPlus on an O365 E3 plan, and have a Power BI Pro Account.
When I try to log into my data catalog, I can't validate with the remote server. I'm using the same Azure AD login for Windows 10 Pro, O365 and Power BI. When I select "My Data Catalog Queries" from the "Get and Transform" menu, I am prompted to log in.
1. I enter my credentials
2. A message flashes up on the screen saying that I have been logged out, which disappears quickly.
3. The Power BI login screen appears in the background with an error message overlayed which says:
I am unable to go past this menu. When I hit "Close", nothing happens, and I am returned to the Excel sheet. If I go back to the Data Catalog Search menu, the experience repeats.
Please check if you can sign in Power BI Service(app.powerbi.com) using this account, also go to Settings in the right upper corner to check if you are a Pro user after you sign in successfully.
Just checked, and when I log into app.powerbi.com with my credentials into app.powerbi.com, I have Power BI Pro. While it doesn't say "pro" anywhere, I have 10 GB of storage.
When I use those same credentials to try to access the Data Catalog in Excel, (Data, My Data Catalog Queries) here's the screen I get.
What is your Excel version? I am unable to reproduce this issue on my side.
Hi Lydia, I had a similar issue but mine doesn't even get to the password stage. Here is the advanced diagnostics id:
Sign in to your account