Forum Discussion
Refreshes for Datasets containing Calculated Tables over Direct Query to AS started failing Mar 30th
Hello, Refreshes of datasets that contain calculated tables from DQ to AS started failing March 30th, 2022. This worked completely fine until March 29th which points to a change at Power BI service...
Hello everyone,
I, too, built a couple of calculated tables with data directly querying a Power BI dataset, only to find out that the report will fail to refresh once published in the service.
The workaround I came up with is not perfect but it works (also, this alternative might only work for smaller datasets...):
(1) create a flow in Power Automate to get the data from the PBi dataset and export as CSV* (way faster and simpler than exporting as an Excel spreadsheet) > (2) query the CSV file instead
My flow uses the Recurrence trigger, I just arranged the order of refresh and trigger schedules.
*Reference: Automatic exports of Power BI data 🤖 | Run a query against a dataset - YouTube, Curbal, ruthpozuelo, Jun 20, 2022
I hope this helps!