Forum Discussion

LeboeufHarry's avatar
LeboeufHarry
Helper I
6 years ago

Deployment Pipelines and Shared Datasets

I saw a similar message on this but not quite the same. My Setup.   First I created a report with a inline dataset as simple as select * from sys.objects (Azure Synaps). I Deployed this to a works...
Need Help
LeboeufHarry's avatar
LeboeufHarry
Helper I
6 years ago

Hi Nimrod_Shalit 

 

A second suggestion, that I could not yet find into the Dataset Rules is to change the login user/password.

It is possible to change Server/Database but not (in the rule) to specify the user.

We use the same userid on all our 3 Synaps Databases but they all have a different password, to secure that a mismatch between version and database would fail.

 

Kr, Harry

 

Nimrod_Shalit's avatar
Nimrod_Shalit
Power BI Team
6 years ago

For security reasons, we cannot pass on passwords across deployments, not create rules for them.

it will work just like any other WS in Power BI-

dataset owner needs to have the creds for the data source, and needs to enter them only once.

for future deployments, only dataset owner can override the dataset, so the creds will not be harmed, either if you have a rule for the data source or not.