Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
MaryamBaghi1
Regular Visitor

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 

data refrsh issu

 

5 REPLIES 5
lbendlin
Super User
Super User

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 .

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

Have you opened a ticket?

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.