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.
Hello, I have the following use case.
I would like my end users to be able to delegate RLS in Power BI. To do so they need to be able write data to SQL Server based on filter selections in Power BI.
I know it's a possible to have a button and send your filter selection to Power Automation and write data to SQL Server that way. However then I will have the additional license cost of Power Automations that I want to avoid.
I would like my end users to be able to start a store procedure in SQL Server with him/hers current filter selection by pressing a button in Power BI.
Is this possible to do, if so how?
Solved! Go to Solution.
Not possible, and not likely any time soon. For now Power Apps or Power Automate is your only (and klutzy) way.
If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41
Not possible, and not likely any time soon. For now Power Apps or Power Automate is your only (and klutzy) way.
If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41
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 |
---|---|
15 | |
3 | |
1 | |
1 | |
1 |
User | Count |
---|---|
26 | |
3 | |
2 | |
2 | |
2 |