Data update with an Update Button (direct query)

[RainerBe]

Hello,

I'm using PBI Desktop and PBI Report Server (Version Jan 2021) on Premise, but without Internet access. So I have no access to the PowerBi Service.

I have configured a Direct Query to  dynamic Data (data insert intervall < 1 minute) and it works fine with the Update Botten  (marked as red) on the PBI RepoertServer

But the report should be called with the embedded view (adding "?rs:embed=true" to the report URL) , so this bar and also the update button is not visible.

Has anyone an idea, how I can "copy" the Update function with an extra button direct in the report?

...and in addition  is there a posibility to configure also an autoaupdate for such a report (on premise, direct query)? I found only solutions with the PowerBI cloudservice so far. 

best regards Bernd 

[RainerBe]

Hi Dedmon Dai, sorry for the late response

clicking just the visuals doesnt' update the data, is there maybay a workaround , for example creating an update button or something like that?

BR Bernd

[v-deddai1-msft]

Hi @RainerBe ,

As far as I know, when you use dq model in your dataset, you don't need to use the refresh button. When you click the visuals in the report, it will send queries to your raw data source in real-time and you will get the latest data from the data source.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai