Power BI Service - Dataset Owner

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

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.