Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Im running a direct query with a DAX table where I'm applying some logic to sum data in different fields. I've removed and summarized data, I'm only createing a table that sums fields based on some criteria. See the DAX here:
I'm getting the following when refreshing the data in the service:
If you are using a calculated table as far as I am aware that will not refresh in DirectQuery because it has to pre-compute the calculated table.
The only option is to have a query to the underlying source in PowerQuery for the DirectQuery to complete.
You will need to refresh the dataset and not the refresh button in the report page.
Go into your dataset and click on Refresh Now as shown below.
Yes, thanks but I'm aware of that. I thought Direct Query would update upon interaction though? This works with other queries I'm working with. I don't want users to have to go in and manually refresh the data as they are monitoring activity.
If you create this table in Power BI Desktop and then use DAX Studio you could see how much memory the table is consuming as well as how many rows it is using.
Here are more details on how to achieve this: How to use Vertipaq Analyzer with DAX Studio for Power BI Model analysis - Reporting/Analytics Made ...
I think that the table is consuming too much memory and I would suggest creating the table in Power Query so that it can be compressed on the way into the dataset.
Hey there, thanks so much for your tip! I followed your advice and have added the new table in power query and I'm not getting the error. However, the data is not updating when I click on the refresh button in the report. I have tried updating in desktop then in the service and even if I wait 15 mins nothing updates. Unless I go into Lineage view and Refresh Now, it won't update like my other Direct Query reports. Any help will be greatly appreciated.