Forum Discussion
Page refresh - hidden switch
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/
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 🙂
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) ?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/