PBIDS Connection File Creation.
If you already have a Power BI Desktop (.PBIX) file that is connected to the data, you may export these connection files from within Power BI Desktop. Furthermore, this is the recommended option because the PBIDS file may be created automatically from the desktop. You may also use a text editor to update or create the file manually.
- Select File > Options and Settings > Data Source Settings to create the PBIDS file.
- Then, in the resulting box, pick the data source to export as a PBIDS, and then click Export PBIDS.
- When you pick the Export PBIDS option in this step, Power BI Desktop creates the PBIDS file, which should be renamed and saved in your directory before being shared with others. You may also open the file in a text editor and make changes to it, such as defining the mode of connection in the file itself.
- If you prefer to construct your PBIDS files manually in a text editor, you must define the necessary inputs for a single connection and save the file with the PBIDS extension. Alternatively, you may select the connection mode as DirectQuery or Import. If mode is missing or null in the file, the user is requested to choose DirectQuery or Import while opening the file in Power BI Desktop.