Forum Discussion
Hide Data Sources
Hi Anonymous ,
Based on this document:
You can create a .PBIDS file to streamline the Get Data experience for report creators in your organization.
When an author opens a .PBIDS file, Power BI Desktop opens and prompt the user for credentials to authenticate and connect to the data source that's specified in the file.
Currently, .PBIDS files only support support a single data source in one file.
So you can create multi .PBIDS files for each data source you want user to use. But they may still connect to other data source if they use pbix file.
BTW, PBIDS as attached. Try to open it with text editor then you will find how it work, For other data sources, you can refer to the Data Source Reference (DSR) format for protocol and address information.
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Li,
PBIDS is clear for me but i do have a couple of questions on the same.
1.Once users move to Transform data (Query editor)/ Visualization pane the Get Data option will still be there, which will allow Users to add use any Data Source.
2. Many Organisations use Message Server for SAP BW connection when i try using the below code i do get an error message.
{
"version": "0.1",
"connections": [
{
"details": {
"protocol": "sap-bw-olap",
"address": {
"server": "xxxxxxxxx",
"systemId": "XXX",
"clientId": "100",
"LogonGroup": "XXXX"
},
}
}
]
}
The one shared in document as example is suitable only for Application Server
Regards,
Sam