Forum Discussion
Page refresh - hidden switch
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?
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#considerations-and-limitations
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂amiskow , this for Direct query and live mode
Refer:https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-automatic-page-refresh
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 🙂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/
6 Replies
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#considerations-and-limitations
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂amiskow , this for Direct query and live mode
Refer:https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-automatic-page-refresh
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?
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 🙂
