connect two different users on same azure database on the same server different pbix files

[Anonymous]

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 · Accepted solution]

@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]

@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]

@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]

@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]

@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]

@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]

@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