topic Re: Set Scheduled Refresh for excel source! in Report Server

Set Scheduled Refresh for excel source!

MaryamBaghi1 — Sat, 25 May 2024 10:54:42 GMT

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

Re: Set Scheduled Refresh for excel source!

lbendlin — Sun, 26 May 2024 01:31:35 GMT

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?

Re: Set Scheduled Refresh for excel source!

MaryamBaghi1 — Sun, 26 May 2024 05:56:07 GMT

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.

Re: Set Scheduled Refresh for excel source!

lbendlin — Sun, 26 May 2024 12:44:27 GMT

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 .

Re: Set Scheduled Refresh for excel source!

MaryamBaghi1 — Wed, 05 Jun 2024 05:13:54 GMT

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

Re: Set Scheduled Refresh for excel source!

lbendlin — Wed, 05 Jun 2024 20:02:40 GMT

Have you opened a ticket?