Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
jbn2343
New Member

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 4
v-haibl-msft
Microsoft Employee
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

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.

jbn2343
New Member

bump

@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)?

 


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors