Hotspot Question You are creating a Power BI dataset from a data source. You want to publish this dataset to Power BI in order to build reports in Azure Synapse Studio. You create your PBIDS file…

Question

Explanation

This question tests your ability to correctly construct a PBIDS (Power BI Data Source) file in JSON format, which Power BI Desktop uses to define and open data source connections for publishing datasets to the Power BI service.

Approach. A valid PBIDS file must be a well-formed JSON document with a top-level 'version' field set to '0.1' and a 'connections' array. Each connection object requires a 'details' object containing a 'protocol' (e.g., 'tds' for SQL Server/Azure Synapse, 'as' for Analysis Services) and an 'address' object with at minimum a 'server' field (and optionally 'database'). An optional 'mode' field can specify 'DirectQuery' or 'Import'. For Azure Synapse Analytics, the server value should be the Synapse dedicated SQL endpoint (e.g., 'myworkspace.sql.azuresynapse.net') and protocol should be 'tds'. Once the PBIDS file is opened in Power BI Desktop, you authenticate, build your dataset, then publish it to the Power BI service, after which Azure Synapse Studio can connect to it via a linked Power BI service.

Concept tested. Correct structure and required fields of a manually authored PBIDS (Power BI Data Source) JSON file, including valid protocol identifiers, address properties, version value, and connection mode - as well as the workflow for publishing a Power BI dataset to be consumed from Azure Synapse Studio.

Reference. https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-data-sources#using-pbids-files-to-get-data

No community discussion yet for this question.