Forum Discussion
Set Scheduled Refresh for excel source!
Hello
I have a file that has 2 data sources. One of the data sources is Excel.
Excel data does not change and is fixed, but because I want to activate Scheduled Refresh on the server, I have to read Excel from OneDrive, but when I enter the link in the url, it seems that it cannot be connected properly because it dosn't show the table that exists.
What should I do?
Thanks
Problem with scheduled refresh error Expression.Error: The field 'SPRequestGuid' of the record wasn'
Report Server Schedule Refresh stays in Refreshing status
5 Replies
When Power Query says "Excel Table" it means an actually defined table in a sheet in your Excel file. Does your table in Excel have a colored header and banded row backgrounds?
Yes, of course.
Now I have uploaded to Google Drive and I can set the refresh .
But I don't know why the refresh doesn't work and it still doesn't work even though it is set.
cannot reproduce, but my OneDrive setup may be different from yours.
If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .
