Forum Discussion
ERROR: OneDrive Excel file as unsupported data source Unable to refresh the model
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 ?
3 Replies
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/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.