Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Autorefresh howto

Hi, I've published a report and I want to autorefresh the dataset as often as possible. I've been reading about LiveConnectors, Report servers, Power Bi service etc etc. In Power BI service it seem...
Need Help
KBO's avatar
KBO
Icon for Memorable Member rankMemorable Member
6 years ago

Hi :),

you have the following options:
Direct Query - Connect direct to the Datasource, for example a SQL DB - the data is always actual

Live Connection - If you modeling the data in a cube in SSAS you can create a Live Connection to Power BI - Same as in Direct Query - You can create jobs tpo refresh your cube

Import - You can refresh your dataset 8 times a day in Pro in Premium 48 times - you can also trigger the datasets via Power Automate (SQL, Excel, ...) 

 

Hope this helps?

 

Best

Kathrin