Forum Discussion

dge7009's avatar
dge7009
Frequent Visitor
9 years ago

Figuring out what Datasource a Dataset is using...

We are in the process of rolling out Power BI to our organization and we are using a gateway to connect to our on premise Analysis Services instance. Under the gateway we have setup two data sources,...
Need Help
Tips and Tricks
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

Hi dge7009,

 

In Power BI desktop, we can check the data source under File -> Options and Settings -> Data Source Settings

 

In Power BI service, go to the dataset management page (gear icon in top right->Manage personal storage). This will give you the list of datasets and for each dataset it will show relative data source information under 'Data Source Credentials'.

 

Best regards,
Yuliana Gu

  • dge7009's avatar
    dge7009
    Frequent Visitor
    9 years ago

    Hey there Yuliana.. I hope all is well. Thanks for the reply. We tried looking, on the service, where you described and though it will tell you what gateway your dataset is using it doesnt appear to tell you which data source on that gateway your data set is using. That's really what we are trying to get at. We wanted to only have one gateway that serviced our DEV data sources as well as our PROD data sources. Since it doesnt appear that there is a way to see the actual data sources behind data sets at this point. I think we are going to go with two gateways one for DEV data sources and one for PROD data sources.

     

    Let me know if I'm just missing something and thanks again for your kind response.

    • v-yulgu-msft's avatar
      v-yulgu-msft
      Microsoft Employee
      9 years ago

      Hi dge7009,

       

      Currently, I haven't found a valid solution that allows us to know the actual data sources behind data sets. 

       

      By the way, whay did you mean 'go with two gateways one for DEV data sources and one for PROD data sources'? Did you mean configure more than one on-premise data gateway on the same Windows server? If so, it is impossible as the on-premise gateway runs as a windows service called "PBIEgwService" on the server where it is installed.

       

      Regards,
      Yuliana Gu

      • dge7009's avatar
        dge7009
        Frequent Visitor
        9 years ago
        Hey Yuliana. I hope all is well. Thanks for the follow up response and confirming my assumption that this isn't currently possible to see the data sources behind a data set from the service. As for the multiple gateways they are installed on separate boxes. One on our Dev box with all our Dev data sources and one on our production box with all our production data sources. It seems to be working well and we can at least verify we are using dev or production resources by seeing what gateway is being used.

        Perhaps I will suggest this as an idea for product enhancement via the forum.

        Thanks again!