Forum Discussion

brentphillips's avatar
brentphillips
Regular Visitor
9 years ago

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 crede...
ankitpatira's avatar
ankitpatira
Community Champion
9 years ago

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's avatar
brentphillips
Regular Visitor
9 years ago

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's avatar
    v-micsh-msft
    Microsoft Employee
    9 years ago

    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