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

  • 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