Forum Discussion
Can't Log into Data Catalog from Within Excel
bftcpa,
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.
Regards,
Lydia
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. My Power BI Home Screen today.
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.
Login screen 1 from within Excel2 - The popup for the MS Authentication3- I enter password4. A message flashes up saying that I've signed out of my account5. I get this message saying that the request couldn't be authorized.
- Anonymous7 years agoNot applicable
bftcpa,
What is your Excel version? I am unable to reproduce this issue on my side.
Regards,
Lydia- mhen-pbi7 years agoNew Member
We are experiencing the same problem.
Excel is version 16.0.10827.20138 (64-bit)
- Anonymous7 years agoNot applicable
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
Request Id: 7d332655-40a7-4ad5-beff-987c0d8f1800Correlation Id: b0e33008-d599-4778-85d8-431df17801b5Timestamp: 2019-01-24T15:53:39.558ZThanks- 007 years agoRegular Visitor
I am having exactly the same issue.
The problem seems to be that even though it indicates that you should provide an organisational account (which would be correct as this is where the Power BI license is) - it is actually not redirecting to our organisational Azure AD and is keeping with the Microsoft Authentication. I can tell this, not only because it does not present with the org branding on the login page - also it will not accept the org password but does accept the microsoft password (on the same email address)
So it seems that Excel is directing to the MS auth method rather than the organizational auth method.
Strange as I am logged into Excel with my Organisational Account!
my version is 16.0.10730.20344
- dglaser7 years agoNew Member
I'm having this exact same issue. I have Excel 16.0.11001.20091 64-bit. Has anyone made any progress on figuring this out?