Thursday, June 8, 2023

Power BI Desktop - Unable To Connect

 Just a quick post on an issue I saw a few people run into lately.

Context

I opened a report with a Live connection to a dataset and I was presented with the error below:

We encountered an error while trying to connect.
Details: "Looks like we're unable to access the dataset. Please contact the owner of the dataset."

Clicking Edit gets you the following dialogue, which might already give you a clue what's happening,



Solution

The answer here is actually really simple, if you know it! 😆 
You have to login to Power BI Desktop with the right account. I was currently logged in with my Powerdobs account, while this was a customer report.

So clicking Edit gave me the datasets in the Powerdobs tenant to connect to, which quickly led me to the conclusion I was logged in with the wrong account.

So to solve this, in the top right corner, click on your name/picture and click Sign in with a different account.


Open the report again and it should connect immediately!
Everyone happy :-)

Featured Post

Governance & Administration - Tenant Settings: Searching

With all the Fabric announcements in the last months, some of the Admin announcements might have slipped through. As you might know, the Adm...