topic Re: Refresh Report Content using API in Developer

Refresh Report Content using API

MarkCBB — Thu, 05 Jul 2018 09:51:49 GMT

Hi there,

I am brand new to using the API, I also have a limited understanding about API's in general.

I have created a simple VBA (Excel) code that pushes data into a streaming dataset using the API.

I have now created a simple Report that is linked to that dataset.

All the above works fine. I would like like to trigger a refresh of the content on the Report page instead of clicking the button "Refresh", is this possible?

I have tried the following:

Function RefreshPowerBIReportPage()
Dim objHTTP As Object
Dim JsonDt As String
Dim sReportKey As String
Dim sGroupKey As String

sReportKey = ""
sGroupKey = ""

Set objHTTP = CreateObject("WinHttp.WinHttpRequest.5.1")

URL = "https://api.powerbi.com/beta/myorg/groups/" & sGroupKey & "/reports/" & sReportKey & "/UpdateReportContent"

objHTTP.Open "POST", URL, False
objHTTP.setRequestHeader "User-Agent", "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)"
objHTTP.setRequestHeader "Content-type", "application/x-www-form-urlencoded"
objHTTP.send


End Function

Re: Refresh Report Content using API

v-jiascu-msft — Fri, 06 Jul 2018 05:40:55 GMT

Hi @MarkCBB,

Since it's a push dataset, the "Refresh" could be different from other general dataset. As far as I know, we need to push the new data through APIs, which acts like "Refresh". So what's the result you expect?

Reference: rest/api/power-bi/pushdatasets and service-real-time-streaming#using-the-streaming-dataset-ui-to-push-data.

Best Regards,

Dale

Re: Refresh Report Content using API

MarkCBB — Fri, 06 Jul 2018 06:13:26 GMT

Hello @v-jiascu-msft,

Thank you for taking the time to help me.

The dataset I am using is a streaming dataset, and it works perfectly on the Dashboard page, however, I have also created a small report page based on the same dataset. the result I am looking for is to have the data in the report page update/refresh itself without the user having to click on the refresh button in the top menu of the report page. The reason for this is that the report page will be displayed on a TV in a call center, and they would like to see the report update as they are working in order to track their real-time performance instead of someone standing up and walking to the TV to click the refresh button.

Re: Refresh Report Content using API

v-jiascu-msft — Fri, 06 Jul 2018 07:01:48 GMT

Hi @MarkCBB,

It should be a dashboard that shows these results in your scenario. Because that's what the dashboard does. I would suggest you vote up this idea. There is a rough workaround. Refresh the whole browser tab in a fixed interval.

Best Regards,

Dale

Re: Refresh Report Content using API

MarkCBB — Fri, 06 Jul 2018 07:12:01 GMT

Voted, thank you for your time Dale.

Re: Refresh Report Content using API

MarkCBB — Fri, 06 Jul 2018 07:16:03 GMT

ahhhh, I see, so I can create a visual in the report and pin that to a dashboard and that visual will update just like the visuals that were created in the dashboard. haha, awesome. thank you

Re: Refresh Report Content using API

v-jiascu-msft — Fri, 06 Jul 2018 07:22:32 GMT

You are totally right. Glad you solved it.

Best Regards,

Dale