Status:
Done
Direct Query fails to work with Azure SQL Database
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 t...
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.