data_refresh
1 Topic
Data refresh on demand from Power BI Server (report built using Import mode)
Hi, using: Power Bi Desktop 2.100.1381.0 64-bit (January 2022) Power BI Report Server Version1.13.8086.22725(January 2022) I created a tabular report in Import mode that retrieves data from DB2 using a (SQL server) linked server. I then uploaded the report to Power BI Server and I am currently refreshing it once every day using the Schedule Refresh option. My problem is that, on source system, data change continuosly and the end user doesn't see refreshed data for the rest of the day. I already discarded the option to increment the Schedule Refresh every 5 minutes due to performance reasons (every 5 minutes a process runs in background on our production server). I also tried the Power Automate option to refresh data on demand, but the version of Power Bi Desktop I am using doesn't support the Power Automate visual. So my question is the following: is there another way in Power BI Server, except the Schedule Refresh, to refresh data on demand (with a report created using import mode)? What the end user needs, is just a button inside the report to refresh on demand the data, but I have no idea how to link the button with the refreshing action. Thanks in advance AlessandroSolved5.7KViews1like5Comments