cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
brentphillips Frequent Visitor
Frequent Visitor

Direct Query not working on app.powerbi

I have created a report in PowerBI Desktop that uses direct query to connect to an Azure SQL Database.

 

I have then published this to the powerbi service, gone to the dataset and entered the credentials for that sql database.

 

However, when i update data in the azure sql database it doesn't show on the report online unless I do a manual refresh.

 

My understanding was direct query goes directly to the database for data. Am i missing something?

 

Thanks!

3 REPLIES 3
Super User
Super User

Re: Direct Query not working on app.powerbi

@brentphillips when you update data in the table in azure sql db (and no interaction on power bi dashboard) then dashboard tiles will be updated automatically approx every 15 minutes. however if you click on slicer or do some filtering for that tile then query will be sent back to azure sql db and you will see the updated data on the tile.

brentphillips Frequent Visitor
Frequent Visitor

Re: Direct Query not working on app.powerbi

Hi Ankitpatira,

 

This is to do with reports. Even after waiting overnight and filtering data it still doesn't direct query data. I have to do a manual refresh to update the data.

v-micsh-msft New Contributor
New Contributor

Re: Direct Query not working on app.powerbi

Hi brentphillips,

 

Have you tried to user fiddler to capture a network trace?

From the trace we could be able to check the query details when interact with Visuals in the reports.

Fiddler Web Debugger Tool

I will try to set up some tests on this, there might be some time delay before I could share any results here.

Regards