Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
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 🙂
@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/
@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 🙂
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/
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 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |