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.
I'm currently holding Pro license. Is it possible that a report with Excel as one of the data sources be in direct query mode that allows refresh for every 15 mins?
The end goal is want to refresh this report every 15 minutes, with Excel sheet involved as one of the data sources.
Thanks in advance!
Solved! Go to Solution.
Hi @Anonymous
You cannot create a DirectQuery / Live connection to an Excel spreadsheet per Microsoft's documentation on Power BI data sources.
You may be interested in this video from Guy in a Cube for a workaround though:
https://guyinacube.com/2021/08/18/can-you-refresh-a-single-table-in-power-bi/
Prior related question:
https://community.powerbi.com/t5/Desktop/using-excel-data-as-direct-query/m-p/190989
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Lucien
Hi @Anonymous
You cannot create a DirectQuery / Live connection to an Excel spreadsheet per Microsoft's documentation on Power BI data sources.
You may be interested in this video from Guy in a Cube for a workaround though:
https://guyinacube.com/2021/08/18/can-you-refresh-a-single-table-in-power-bi/
Prior related question:
https://community.powerbi.com/t5/Desktop/using-excel-data-as-direct-query/m-p/190989
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Lucien
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 |
---|---|
8 | |
5 | |
4 | |
2 | |
2 |
User | Count |
---|---|
12 | |
7 | |
7 | |
2 | |
2 |