Scheduled refresh failing, errors in query refresh with no records in table after keeping errors.

[Anonymous]

Hello,

 I recently published my Power BI report and tried to setup scheduled refresh but it has failed everey time I try to run it. I think it might have something to do with this error that can be seen in the screenshot below but I am not sure what is causing that because when I look at in the Query Editor it shows no records. Any ideas what might be causing this?

[v-easonf-msft]

Hi， @Anonymous 

Has the data source been modified recently?

Please check whether the pbix on the desktop can be refreshed normally.

Best Regards,
Community Support Team _ Eason

[Dinesh_Suranga]

@Anonymous 

Hi,

Go to power query editor and select SPFolder table.

Check all the cells in the table. Thee should be 26 or more than 26 error cells in your table. Click on one error cell and it will show you the error. Fix that error then it will be fine.

Thank you.

[kpfootball1028 · Accepted solution]

I actually was able to find the answer to why it was not refreshing properly. The privacy settings in my PowerBI Desktop queries did not match the settings in the online portion which caused an error when initiating a refresh from the web. Once I set those to match it worked.