Direct Query mode with Excel as one of the data sources

Anonymous — Mon, 12 Sep 2022 22:43:23 GMT

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!

Re: Direct Query mode with Excel as one of the data sources

v-luwang-msft — Tue, 13 Sep 2022 02:36:07 GMT

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/

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,
Lucien

topic Direct Query mode with Excel as one of the data sources in Report Server

Direct Query mode with Excel as one of the data sources

Re: Direct Query mode with Excel as one of the data sources