Page refresh - hidden switch

[amiskow]

Hi, I'm new here and I need help. I was looking for answers on the form but I did not find the answer

Why can't I see this switch?

I have enabled this functionality in options

My desktop looks like there is no scheduled refresh switch. What am I doing wrong?

[nandukrishnavs · Accepted solution]

@amiskow 

It will show only if you are connecting as DirectQuery mode.

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-automatic-page-refresh#consideratio...
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

[amitchandak · Accepted solution]

@amiskow , this for Direct query and live mode

Refer:https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-automatic-page-refresh

[nandukrishnavs · Accepted solution]

@amiskow  Excel source doesn't support DirectQuery.

Refer to this link

https://docs.microsoft.com/en-us/power-bi/connect-data/power-bi-data-sources

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

[amitchandak · Accepted solution]

@amiskow , this for Direct query and live mode

Refer:https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-automatic-page-refresh

[amiskow]

Thank you for the answer.

How to make a DirectQuery for an Excel file?

If I choose the source (Excel file), the program imports it without asking. How do you switch to a DirectQuery?

[nandukrishnavs · Accepted solution]

@amiskow  Excel source doesn't support DirectQuery.

Refer to this link

https://docs.microsoft.com/en-us/power-bi/connect-data/power-bi-data-sources

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

[amiskow]

That's not good. I thought it would be possible 😞
So it is not possible to auto refresh the query from the Excel table (we are talking only about PowerBI desktop) ?

[nandukrishnavs · Accepted solution]

@amiskow 

FYI - If you are keeping your excel files in the SharePoint folder/Onedrive, you can use Microsoft flow to automate the data refresh. 

https://powerbi.microsoft.com/en-us/blog/refresh-your-power-bi-dataset-using-microsoft-flow/

https://www.youtube.com/watch?v=-qei9MS_8Ic

[nandukrishnavs · Accepted solution]

@amiskow 

It will show only if you are connecting as DirectQuery mode.

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-automatic-page-refresh#consideratio...
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂