Forum Discussion
Direct Query to Excel Sheet
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?
1 Reply
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
