topic Re: Data update with an Update Button (direct query) in Report Server

Data update with an Update Button (direct query)

RainerBe — Mon, 15 Mar 2021 10:10:58 GMT

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

Re: Data update with an Update Button (direct query)

v-deddai1-msft — Wed, 17 Mar 2021 03:56:26 GMT

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

Re: Data update with an Update Button (direct query)

RainerBe — Fri, 22 Apr 2022 07:44:07 GMT

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