Forum Discussion

Photoguy190972's avatar
Photoguy190972
Regular Visitor
5 years ago

Refresh Issues

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 ...
Need Help
GilbertQ's avatar
GilbertQ
Super User
5 years ago

Hi Photoguy190972 

 

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 easy with FourMoo and Power BI

 

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.

  • Photoguy190972's avatar
    Photoguy190972
    Regular Visitor
    5 years ago

    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.