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

[Chanleakna123]

Hi , i have imported my file from Google Spreadsheet , when i refreshed it was error and pop out such message. 

need a solution , how to avoide this ? 

Thanks with Regards

[v-juanli-msft · Accepted solution]

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/...

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

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

[Chanleakna123]

i have solved this by changing the source 🙂 

Thanks you @v-juanli-msft