Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Power BI Service - Dataset Owner

Hi I Power BI Service when you publish a reprot and go to data set settings you notice a warning message like this image below. The Dataset is configured by someone else and would you like to take ov...
General Comment
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    ######################

    To all those run into the same problem.  Here is  the outcome of the MS support and I have also test by running profiler. 

    ######################

     

    If you are using Azure Data Warehosue as your source and intend to use Multiple Service Accounts - You cannot use multiple service accounts.  

    If you want end user to access the report using thier Access token you turn on Single Sign On Option. This happens on the Data Source level i.e. Data Warehosue Level. Changing this option anytime later for the same source will impact on "All" the reports pointed towards same data warehosue.

     

    If you dont turn on Single Sign On , you can use your personal account or service account to connect to DW, this again changes at Data Source Level, not on the Power BI Dataset and Data Source Level. 

     

    This means even though UX allow you  to configure data source credentials at each dataset level when you are set as dataset owner changing the credential applies to all reports not the just the dataset in question. 

     

    To be honest it is a bit disappointment for me as i was expect that we should able to configure Dataset Specific user credential.

     

    Anyways , may be it is road map.   

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anand, 

Thanks for the reply. Much Appreciated 

When i read my own 2nd question I see it was confusing.  Here is my rephrased 2nd question. 🙂

 

I can have another report[dataset] in the same workspace for the same source[ADW] but use different login credentials specifc for the second report[dataset]?

 

Thanks 

Anand24's avatar
Anand24
Icon for Super User rankSuper User
6 years ago

Anonymous, Yes you can !

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    ######################

    To all those run into the same problem.  Here is  the outcome of the MS support and I have also test by running profiler. 

    ######################

     

    If you are using Azure Data Warehosue as your source and intend to use Multiple Service Accounts - You cannot use multiple service accounts.  

    If you want end user to access the report using thier Access token you turn on Single Sign On Option. This happens on the Data Source level i.e. Data Warehosue Level. Changing this option anytime later for the same source will impact on "All" the reports pointed towards same data warehosue.

     

    If you dont turn on Single Sign On , you can use your personal account or service account to connect to DW, this again changes at Data Source Level, not on the Power BI Dataset and Data Source Level. 

     

    This means even though UX allow you  to configure data source credentials at each dataset level when you are set as dataset owner changing the credential applies to all reports not the just the dataset in question. 

     

    To be honest it is a bit disappointment for me as i was expect that we should able to configure Dataset Specific user credential.

     

    Anyways , may be it is road map.