Forum Discussion

cleovii's avatar
cleovii
Helper I
7 years ago
Solved

Refresh Workarounds

Hi everyone!   One of our customers currently has >50 Pro licenses. Eight refreshes a day isn't enough for what they need to do, but $5000/mo for a node just doesn't make sense for their business r...
Need Help
Tips and Tricks
  • cleovii's avatar
    cleovii
    7 years ago

    Hi everyone! They ended up purchasing Premium, but I wanted to update you all with my findings.

     

    The best option I came across was a blend of DQ and Import, where the DQ interacts with evolving data, and the import is strictly static information. This option would offset the heavy load of interacting with frequently refreshing information.

     

    I hope this helps others!

cleovii's avatar
cleovii
Helper I
7 years ago

I thought I would update my post with some of my own research for other visitors.

 

This post suggests DirectQuery as an option, as opposed to import. However, I know that DirectQuery is strongly recommended against by users of Power BI. Does anyone who has experience with DirectQuery have any insight? I imagine that complex machinations would be difficult to accomplish, and that the usage costs would spike tremendously.