Step 5: start Power BI Desktop and create a connection to Azure SQL Database. Enter the SQL on-demand endpoint name as the server name, then the database name and Direct Query as the connectivity ...

When you import data from a relational database like SQL Server in Power BI you have the option of entering your own SQL query to use as a starting point: Here’s the M code for a query that does this: ...