Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I'm trying to publish a report that uses and OData connection for one of the graphs that pulls from Microsoft Graph Teams data. It works great in Power BI Desktop, as I'm able to authenticate using the Single Sign On that I'm used to with all Microsoft products while connected to my company's VPN. However, once we've published to powerbi.com and try to set up an automatic data refresh, the OData connection will not authenticate using OAuth2, which should be the single-sign on. It gives the message listed in the screenshot attached:
There's also this in the json that gets generated when I put in the url in the screenshot:
{ "error": { "code": "InvalidAuthenticationToken", "message": "Access token is empty.", "innerError": { "date": "2020-06-16T17:32:26", "request-id": "62268e1d-dad2-4569-a273-b6177f398b6d" } } }
Is there something I'm doing wrong or is there another way I have to generate an access token?
Hi @Anonymous ,
This error can pop up if you have the desktop file and the Service with different privacy levels. Can you confirm that they are the same for the datasource on each side?
Proud to be a Datanaut!
Private message me for consulting or training needs.
Both are set to Organizational currently, and it seems to go through the same process each time to try and do the single-sign on, but on the Service then tells me that the credentials are invalid.
Hi @Anonymous ,
Ok, I am wondering if you have MFA setup and that is causing an issue? And, I know it sounds silly, but have you tried to do this in another browser as well? That said, it truly might be as easy as you need a new token (perhaps it expired by cache and/or by date or something).
Proud to be a Datanaut!
Private message me for consulting or training needs.
What's an MFA setup?
Just tried it in IE (was told to use a different browser), Edge (in addition to the original error I was told that I needed to use SSL (HTTPS) when you use OAuth 2.0 authentication, which I already am so confused there), Firefox (would not let me log into powerbi.com using the same credentials), and Chrome, where the issue originated.
Hi @Anonymous ,
MFA means Multi-Factor Authentication (as in, your phone gets a code to confirm it is you when you sign in.)
Proud to be a Datanaut!
Private message me for consulting or training needs.
No, no multi-factor authentication is set up. I just click and it takes me through a sequence of pages that validate my username through my company's firewall etc.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.