Can't Log into Data Catalog from Within Excel

[bftcpa]

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:

• Problem Signing In
• A request couldn't be authorized.  Please make sure you're logged in with an account authorized to perform this action.

 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.

Help!

Thanks, Brian

[v-yuezhe-msft]

@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

[bftcpa]

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.

[dglaser]

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?

[v-yuezhe-msft]

@bftcpa，

What is your Excel version? I am unable to reproduce this issue on my side.

Regards,
Lydia

[Anonymous]

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-987c0d8f1800

Correlation Id: b0e33008-d599-4778-85d8-431df17801b5

Timestamp: 2019-01-24T15:53:39.558Z

Thanks

[00]

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

[JonesTrac]

I'm having the same issue, Excel isn't redirecting to our Org sign in at this point. When I enter my org username it just says no Microsoft account exists with that username.

[mhen-pbi]

We are experiencing the same problem.

Excel is version 16.0.10827.20138 (64-bit)