Forum Discussion
Access Power BI Datasets in Excel - Connection Error
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.
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"
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.
2 Replies
Note - i've already installed "Analyse In Excel" addin.
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.
