Power Query Data Source Error

Question

Dear, 

I used onedrive file as data source in excel power query which was done successfully on yesterday and created Pivot Table to summaries my data in required form. now today when I am refreshing data, getting error as per attached. Please support to resolve this issue so that I can use this wonder full excel feature to accomplish my important tasks. 

Regards

Dilawer

Answer 1

Thank you Chitrahaas, 

Error came for very short time and from last 3 to 4 days I havnt faced any issue syncing data from online sheet to power query. I closed the file and reopened it, then did not faced same issue again. still want to see what error was there attached is the screenshot. 

Regards

Dilawer

[PII is masked by Chitrahaas Nalla MSFT]

Answer 2

Hi Dilawer,

Thanks for writing back and letting us know.

Glad to hear problem is resolved after reopening the file and not encountering any error messages. For the error provided in the screenshot, the most possible solution is removing the data source and reconnecting it. Since, you can’t reproduce the problem, in future if you still encounter with similar error, please feel free to post back and we will put our efforts to resolve it.

Thanks,

Chitrahaas

Answer 3

Hi Dilawer,

Please provide the screenshot of the error message encountered at your convenience.

Thanks,

Chitrahaas

Answer 4

Hi Dilawer,

We’re sorry for the inconvenience caused by the problem.

Can you please re-attach the screenshot of the error message encountered when you try to refresh the data source? It helps us to better understand the problem.

To insert a screenshot, please follow the steps below:

Click on the reply in the thread> Click on Insert image (Highlighted part in below screenshot)> Browse> Open> Select the screenshot> Upload.

Thanks,

Chitrahaas