Hide Data Sources

[Anonymous]

Hi All,

Do we have any option available to Hide Data Sources for Users.

As we do not want all default Data Sources been provided for self service reporting and enable only which are approved.

Regards,

Sam

[Anonymous]

Hello, 

Attempting to resurrect this post as I am in a similar position.  The issue is that we would like to hide the 'Active Directory' Data Source in the Desktop app (Get Data) and .PBIDS is not a workable soultion for us.  I have attempted to research as much as possible, but no dice.

So I wondered if anyone has dealt with the same requirement and if so, how/if they resolved?

Thanks,

adt.

[PattemManohar]

@Anonymous  Could you please elaborate a bit more detail. 

When you say, want to hide the Data Sources to users - Where exactly you mean ?

[PattemManohar]

@Anonymous  Looks like you need to use the latest October 2019 release feature .PBIDS file creation which enable the report builders to use only the Datasources that are restricted to, as defined in the Power BI Data Source file (.pbids)

https://docs.microsoft.com/en-us/power-bi/desktop-data-sources

[Anonymous]

Hi Manohar,

Thanks for your Quick responce,

Do we have option where we can disable/Hide the current data sources.

PBIDS can i have only one data source and not more.

Regards,

Sam

[v-lid-msft]

Hi @Anonymous ,

Do you mean hide the data of some data source or not connect some data source ,based on the user using who are using your report?

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.

[Anonymous]

Hi Li,

When we select Get data we will listed with N number of data source connectors.

We would like to limit their visibilty like use only internally approved connectors, SAP BW Application Server, Odata and etc.

But not allow end users for connecting to few data sources like example Wed and etc..

Regards,

Santosh

[v-lid-msft]

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.

[Anonymous]

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