Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
gajinder47
Frequent Visitor

Power BI Service to Azure SQL Database Credentials Issue

So ,

We require to publish a single database (with Multiple credentials for each tenant/user as we are using SQL Row Level Security for limiting the row level view for each user) to Power BI service multiple times, Although as written each time the SQL credentials are different.

We will then share the Datasets through content Pack.  This whole setup was working absolutely fine  as we were able to see data that should only be visible to a certain user through RLS up until now.

Now when we publish the dataset it says the following although we are not using any Gateways (Enterprise or Personal) in our solution 

 

sUntitled.png

 

I think it is a big with either PBI Service or Desktop. Please let me know your understanding , Thanks for reading 🙂

1 REPLY 1
Eric_Zhang
Employee
Employee

@gajinder47

Is Azure SQL DB the only database in your report? Can you check the dataset after published to see it actually uses a gateway or not?

Capture.PNG

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors