Set Scheduled Refresh for excel source!

[MaryamBaghi1]

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 

data refrsh issu

[lbendlin]

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?

[MaryamBaghi1]

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.

[lbendlin]

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 .

[MaryamBaghi1]

Hello
I completed the settings, but I noticed that it does not refresh automatically!
I open the program manually and do it myself. Do you have a solution?

Thank you for answering

[lbendlin]

Have you opened a ticket?