Error when loading the dataset from Power BI in Excel

[lorenzofarella]

I’m experiencing an issue with an Excel file connected to Power BI. Using the same credentials, I can connect to the data source on some PCs, but on others, I receive the following error: “An error occurred while loading the dataset 'pbiazure://api.powerbi.com...’” (see attached screenshot).
 I have already confirmed that the credentials are correct. What could be causing this issue, and how can I resolve it?

[lorenzofarella]

Hello,

This isn’t an account or credential issue; the access to the data model varies from one PC to another. I’ve verified that both the Excel account and license are correct, and I also checked the account through the “File -> Account” menu as suggested, but the issue persists only on certain devices.

[Gabry]

Capito. Non saprei allora. Mi era capitato lo stesso problema ed era legato all account con cui si leggeva excel, per qualche motivo era come se leggesse l'utente di Windows e non l'account con cui ero loggato su excel, avevo risolto loggandomi dal menù file dove vedi anche la licenza.

Magari prova da quel PC usando excel su web loggandoti con quell account e vedi se in quel caso va altro non saprei consigliarti ciao 

[Anonymous]

Hi @lorenzofarella ,

Gabry  response was clear and here is what I need to add. The account you are using must have “Generate” permissions to the Power BI semantic model or at least a “Participant” role in the Power BI workspace that contains the semantic model. You must have a Fabric license: Fabric (Free Edition), Pro Edition, or Premium Per User (PPU) Edition license. Also, as Gabry  mentions, you need to make sure that the logins are consistent.

Connect Excel to Power BI semantic models - Power BI | Microsoft Learn
Power BI semantic model experience in Excel - Power BI | Microsoft Learn

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Gabry]

Ciao Lorenzo,

looks like a credential issue. Have you checked if the excel account logged in has access to the datamodel? Also excel license? Also double check wich is the account logged into excel, from the file -> account menu. Not just from the top right menu