The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 |
---|---|
43 | |
15 | |
13 | |
13 | |
9 |
User | Count |
---|---|
50 | |
43 | |
24 | |
22 | |
18 |