Forum Discussion

FreddySetiawan's avatar
FreddySetiawan
Advocate II
6 years ago

PowerBI - Direct Query & Cache

HI Guys, I'm one happy student that likes to learn.   So, I'm stumble with PowerBI Desktop. I have an Azure SQL which always get new dataset as often as the user wants. I'm building report on Po...
Need Help
FreddySetiawan's avatar
FreddySetiawan
Advocate II
6 years ago

FarhanAhmed thanks for helping me repro the issue.

I can't click Refresh as my Live dataset is pretty huge... and refresh data is not available on DirectQuery table.

  • FreddySetiawan's avatar
    FreddySetiawan
    Advocate II
    6 years ago

    FarhanAhmed I did, but it doesn't change anything.

    I enabled performance analyzer and see that there's update every now and then when there's a change.

    I also start DAX Studio and monitor there. indeed there's query running to check.

     

    However I think it boils down to the fact that the calculated column is not recalculated.

     

    If I create new viz just using dataset from DirectQuery table, I can see the new rows.

    But on my ImportedTable calculated column, it doesn't show anything, until... I change something on the formula