Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi there,
Has it ever worked with going down to the SQL Server source?
I have only done Direct Query RLS to an SSAS Server, so not exactly sure how it would work with SQL Server
Hi there,
Ok that is for imported datasets, I forgot that yours was DirectQuery.
The only other thing to check for is to ensure that your gateway is mapping the usernames correctly through to your SQL Server source.
I would run Query Profiler on your SQL database and check to see if it is passing through the correct username?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
20 | |
19 | |
18 | |
9 |