Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. Register now

0

Direct Query fails to work with Azure SQL Database

Submitted by Anonymous on ‎03-17-2023 01:54 PM

This problem is only when using Direct Query, no issues with Imported.

 

 

On Data Refresh, PowerBI complains that it cannot load the model, despite Power BI seeing the views and the data inside them just fine. 

 

I can 100% confirm that SQL Server is 100% reachable and operational.

It is not a SQL Server or firewall or network issue.

 

This problem only occurs when using Direct Query, Imported works fine. Seems like a PowerBI bug.

 

I would prefer to use Direct Query over Imported for several reasons.

 

 

 

 

But when refreshing,

claudiop_0-1679086257107.png

 

 

Status: Delivered
See more ideas labeled with:
2 Comments (2 New)
Comments
Anonymous
Not applicable
‎03-17-2023 02:12 PM

In case this helps PowerBI Team fix the bug: 

 

The issue was supplying the port number to PowerBI. Removing the port number and letting PowerBI use SQL's default port number instead appears to have fixed. PowerBI seems to be working fine now. 

 

Anonymous
Not applicable
‎03-19-2023 06:17 PM

Glad your Power BI back to normal!

Thanks for your sharing and this thread will be closed.

 

Best regards.
Community Support Team_ Caitlyn

Idea Statuses