Forum Discussion

jbn2343's avatar
jbn2343
New Member
9 years ago

publish refresh

I've created a report using the desktop app, the data comes from Azure SQL Data Warehouse. 

 

When I publish the report, it says "the published report has been configured to use an enterprise gateway" which is confusing since the dataset connects to data in Azure. Can anyone explain this?

 

Further, the data on the published report never updates even though it says it's refreshing every 15 minutes. No error message or anything helpful to understand what's happening.

 

How do i fix this?

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      jbn2343 Couple questions.

      1) Did you import or are you using Direct Query?

      2) Are you referring to the Dashboard when you say it is refreshing every 15 minutes, or is there a refresh time next to the dataset?

      3) Are you only connecting to the Azure SQL Data Warehouse, or do you also connect to a different data source (This would only apply to in import scenerio)?

       

  • v-haibl-msft's avatar
    v-haibl-msft
    Microsoft Employee

    jbn2343

     

    Based on my testing and the warning message you received, you should be using Direct Query. But I’d still like to confirm it with you. We need to make sure you are using SQL AZURE Data source only in the PBIX. Please post back when you’re available.

     

    Best Regards,

    Herbert

    • jbn2343's avatar
      jbn2343
      New Member

      direct query

      data source is sql azure data warehouse

      I can see the data source refreshes every fifteen minutes, but the data is not updated. In the PowerBI desktop app the data updates fine.