I have a problem with Direct Query

[BrianKim]

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 ?

[Eric_Zhang · Accepted solution]

@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.