Solved: connect two different users on same azure database...

Anonymous · ‎09-11-2018

Hi,

I have a challenge.

I have 2 pbix files. They are both connected to same Azure SQL server and same database.

BUT it is 2 different users in these 2 files. I thought the 2 files where stand-alone from eachother but when I change credentials in one file then when I open the other file the credentials are automatically changed there as well. How to create a unique source allthough it is same server and database?

The two different users access different data from the database. That is why I need different credentials.

Thanks!

/Kris

Anonymous · ‎09-12-2018

@Anonymous,

For same server name and same database name, Power BI Desktop only store a credential in Date source settings->global permissions, this is the reason why credentials are automatically changed there as well when you open other PBIX file.

In your scenario, I would recommend you create a single Power BI report using an admin account, and then define Row Level Security in your dataset.

Regards,
Lydia

View solution in original post

Anonymous · ‎09-12-2018

@Anonymous,

For same server name and same database name, Power BI Desktop only store a credential in Date source settings->global permissions, this is the reason why credentials are automatically changed there as well when you open other PBIX file.

In your scenario, I would recommend you create a single Power BI report using an admin account, and then define Row Level Security in your dataset.

Regards,
Lydia

Anonymous · ‎09-13-2018

@Anonymous

Hi Lydia,

I'm only fetching this data from HQ and they only give us access with two user accounts for the different divisions. Does this mean that this is not possible to solve in Power BI Desktop or does a workaround exist?

Thanks!

/Kris

Anonymous · ‎09-13-2018

@Anonymous,

The workaround that i can think of is to use different server name or different database name in the two PBIX file.

Regards,
Lydia

Anonymous · ‎09-13-2018

@Anonymous

Is it possible to give a alias to the server or the db som that they can be separated by alias? Is that what you mean?

If that is possible, how do I do that?

Thanks!

/Kris

Anonymous · ‎09-14-2018

@Anonymous,

Yes. You can set alias for the Azure SQL database, then it is possible to provide different server name in the two PBIX file.

Regards,
Lydia

Anonymous · ‎09-14-2018

@Anonymous

Thank you!

But then I assume that it is not possible to set alias on the server or DB in Power BI Desktop?

That would then be the solution since I then can have 2 servers in the list with 2 different log in credentials.

/Kris

Anonymous · ‎09-14-2018

@Anonymous,

In Power BI Desktop, it is not possible to set alias for server or database. You would need to use Powershell as described in the above blog.

Regards,
Lydia