!!!Error on Refresh of File Imported from Google Spreadsheet

Hi Chanleakna123

Have you modified the relationships in the model or maybe clicked around to "Autodetect..." ?

Without any detailed information, it is hard to say why this error occurs.

 

There are some threads disscussing about the similar errors, please check to test on your site.

https://community.powerbi.com/t5/Desktop/Load-was-cancelled-by-an-error-in-loading-a-previous-table/td-p/3319

https://blogs.msdn.microsoft.com/samlester/2018/02/07/troubleshooting-a-power-bi-dataset-refresh-error/

 

 

in a summary for information above 

check the data type for some columns, or table/column name, duplicate entry in the database, then go to edit query to modify.

 

 

In Power BI Desktop, we can enable tracing log via File –> Options –> Diagnostics –> Enable Tracing. When we meet the error when use Power BI desktop, we can go to check detail information. Please take a look at links below:

 

Power BI Desktop Trace Logs Analyser

Power BI Diagnostics, Trace Logs And Query Execution Times (Again)

 

Best Regards

Maggie