ERROR: OneDrive Excel file as unsupported data source Unable to refresh the model

[Anonymous]

Hello! 

I currently have an excel file on a shared OneDrive (for Business) folder with a data model and a powerquery table. 

I decided to import this excel dataset to power BI to make a better Report and easier to access. 

After creating the report i encountered the problem below upon refreshing:

Data source error: Unable to refresh the model (id=3715234) because it references an unsupported data source.
Cluster URI: WABI-BRAZIL-SOUTH-redirect.analysis.windows.net
Activity ID: 96b890d7-9559-49d5-97bf-76ca84417bc2
Request ID: 3ecda9ac-360a-53d0-5f8b-17560b2f72b5
Time: 2021-09-01 23:46:46Z 

The report was created using Power BI service.

Also, the excel file has no external connections to any other files. The only thing different it contains are some formulas from an internal add-in. But given that im only using it as a dataset "Import" and not "connect", it shouldnt be a problem. 

i also tried deleting and importing again a copy of the file. The import also goes well but when i try to refresh after, the same error ocurred. 

Can you anyone please help me figure out what is going on ?

[Anonymous · Accepted solution]

In case anyone everfinds this topic, here is the solution i found:

Its happens that excel on sharepoint doesnt support Power Query. When i removed the power Query from my workbook it started working. 

[Anonymous]

Hi  @Anonymous ,

You can directly use Power BI Desktop to connect to this OneDrive Excel.

This is the connection process:

https://www.c-sharpcorner.com/article/connect-to-onedrive-excel-file-from-power-bi-desktop/

This is the related document, you can view this content:

https://community.powerbi.com/t5/Desktop/Unable-to-refresh-the-model-id-1203169-because-it-references-an/td-p/339776

https://community.powerbi.com/t5/Power-Query/Refresh-Error-Unable-to-refresh-the-model-id-2682215-because-it/m-p/198568

https://community.powerbi.com/t5/Service/model-references-an-unsuported-data-source/td-p/276831

Best Regards,

Liu Yang

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

[Anonymous]

Thanks for the help but i had to find the answer elsewhere. 

Its happens that excel on sharepoint doesnt support Power Query. When i removed the power Query from my workbook it started working.