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: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

0
claudiop

Direct Query fails to work with Azure SQL Database

Submitted by Microsoft Employee 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

Glad your Power BI back to normal!

Thanks for your sharing and this thread will be closed.

 

Best regards.
Community Support Team_ Caitlyn

See more ideas labeled with:
2 Comments (2 New)
Comments
claudiop
Microsoft Employee
Microsoft Employee
‎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. 

 

v-xiaoyan-msft
Community Support
Community Support
‎03-19-2023 06:17 PM
Status changed to: Delivered

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