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
Icon for Microsoft Employee rankMicrosoft 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.