SQL examples for SQL Server

The following SQL examples demonstrate common use cases for this connector. Select a scenario below to view the query syntax and parameters required to interact with Power BI.

• Bulk create rows using SQL Server data
• Call generic API request
• Call generic API request with URL parameters
• Create a push dataset
• Create a push dataset with multiple tables
• Create rows
• Create rows in a dataset
• Delete a dataset
• Execute a DAX query (advanced)
• Execute a DAX query (complex filter)
• Execute a DAX query (evaluate table)
• Execute a DAX query (filter)
• Execute a DAX query (select columns)
• Execute a DAX query (top N)
• Read a dataset by ID
• Read a workspace by ID
• Read dataflows
• Read datasets
• Read datasets in a workspace
• Read table columns
• Read table columns in a dataset
• Read table rows
• Read table rows (using function)
• Read table rows in a dataset (using function)
• Read table rows in a workspace and dataset
• Read tables
• Read tables in a dataset
• Read workspaces
• Refresh a dataflow
• Refresh a dataflow (async)
• Refresh a dataflow (wait for completion)
• Refresh a dataset (async)
• Refresh a dataset (wait for completion)
• Truncate a table
• Truncate a table in a dataset