DP-500 · Question #89
You have a PostgreSQL database named db1. You have a group of data analysts that will create Power BI datasets. Each analyst will use data from a different schema in db1. You need to simplify the…
The correct answer is C. PBIDS. A PBIDS (Power BI Data Source) file stores pre-configured connection details, allowing analysts to open Power BI Desktop with the database connection already populated.
Question
Options
- APBIT
- BPBIX
- CPBIDS
How the community answered
(31 responses)- A6% (2)
- B10% (3)
- C84% (26)
Why each option
A PBIDS (Power BI Data Source) file stores pre-configured connection details, allowing analysts to open Power BI Desktop with the database connection already populated.
A .pbit file is a Power BI template that bundles report layout, queries, and parameters but is not designed as a lightweight, shareable data source connection shortcut.
A .pbix file is a full Power BI report file containing data, visuals, and the data model; it is not intended for sharing connection details without accompanying report content.
A .pbids file is a JSON-based file that contains data source connection parameters such as server address, database name, and authentication mode. When an analyst opens this file in Power BI Desktop, the Get Data dialog is pre-populated with the PostgreSQL db1 connection details, eliminating the need to manually enter connection information each time and simplifying the initial connection process.
Concept tested: PBIDS file for simplifying Power BI data source connections
Source: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-data-sources#using-pbids-files-to-get-data
Topics
Community Discussion
No community discussion yet for this question.