I have a problem with Direct Query

BrianKim — Tue, 29 Nov 2016 09:20:18 GMT

Hi! I have a report that gets data from Azure SQL DB instance. I have set up everything work fine on PowerBI desktop and BI service. I chose the option of Direct Query.

I have imported the report into a workspace and embedded it into my website, but it doesn't show the data updated.

Let me show you guys what I did. I have no idea what the problem is.

I made a dashboard on BI desktop and I inserted only one row into the table.

And then I saved the pbix file. After that I inserted one row more into the table.

I published the pbix file into BI service.

When I push the refresh button on PowerBI service, it shows the updated data.(two rows)

But when I push the refresh button on the website, it doesn't show the updated data at all

How can I solve this problem ?

Re: I have a problem with Direct Query

Eric_Zhang — Thu, 01 Dec 2016 09:20:27 GMT

@BrianKim

I see you're using the "Publish to web" feature to embed the report, right?
It is not real-time, approximately one hour latency, check How Publish to web works (technical details).

For real-time embeding purpose, either embed reports via Power BI REST API or Power BI Embedded. Also check the difference Rest API vs Power BI Embedded.

topic I have a problem with Direct Query in Developer

I have a problem with Direct Query

Re: I have a problem with Direct Query