The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
It sounds like I can have Power Bi Online access live data from Azure SQL Server DB, or Spark or Warehouse...without the need to refresh data or any of that.
I was wondering how I would implement user security. Lets say I have orders that are handled by certain advertisers. And a User has access to some advertisers (via AdvertiserUsers table). How would show a report/dashboard of Orders for a specific user who has logged in to see my dashboard in Power Bi Online?
When it queries the live data (whether its Azure SQL Server DB, or Spark or Warehouse), does it pass the identity of the user so that I can filter the results?
User | Count |
---|---|
35 | |
14 | |
11 | |
11 | |
8 |
User | Count |
---|---|
44 | |
43 | |
19 | |
18 | |
17 |