Access Power BI Datasets in Excel - Connection Error

[antelk]

Hoping someone can help with an error connecting to Power BI datasets via excel. I'm seeing the following error (refer for screenshot below). Note - i'm able to connect without issue on other machines. Thank you. 

"Sign in to view your datasets

An error occurred when trying to sign into Power BI.

Please try again later.

Connection with Power BI error

Unable to connect to Power BI to load your datasets. Please try again or contact Power BI support.

If you contact support, please provide these details.

FetchDatasets was unsuccessful

• RequestID: 2521e9b2-0b53-4f49-8f1e-673e6c89a7d8
• Status code: 401
• Time: Mon, 08 Mar 2021 23:37:05 GMT
• Version: 1.79.0"

[Anonymous · Accepted solution]

Hi @antelk 

1. Please check whether the account you use to sign in to Excel is the same account as Power BI.

   Or whether this account has permission to access dataset to load data.

   If your account doesn't permission,   please contact to report owner to ask him to check and fix your access  permission .

2. Please check your license.

Analyze in Excel requires that the dataset be in Power BI Premium or that the user have a Power BI Pro license.

3. For reference: Connection cannot be made error

   The primary cause for a connection cannot be made error is that your computer's OLE DB provider client    libraries  are not current.

    Refer to this Update Excel libraries for the OLE DB provider to update your Excel libraries.

Best Regards,

Rico Zhou

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

[antelk]

Note - i've already installed "Analyse In Excel" addin.