Direct Query to Excel Sheet

[joshua1990]

We have some dataflows that query data from our ERP system. We split these dataflows into dimensional and transactional data/ tables since we don't need to refresh the dimensional data so often.

Then we have a report with a text section at the bottom. This way we can embed individual text by using a simple excel sheet.

When we update the excel sheet, we always have to update all dataflows and the excel sheet in the PBI service. This can take a huge amount of time.

Is there any way to use a direct query to an excel sheet? So that we always have the latest data from the excel available?

[AlexisOlson]

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