Access Power BI Datasets in Excel - Connection Error

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.