Forum Discussion
Direct Query mode with Excel as one of the data sources
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!
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/190989If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Lucien
1 Reply
- v-luwang-msft
Community Support
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/190989If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Lucien