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,
We have clients who have many custom tables in their database. We are trying to give all of them Power BI Embedded access and allow them to build reports on their own custom tables, but we don't want to manually created a dataset for all of them.
Is there a way to programatically create a dataset via a script or something where it grabs all tables based on a certain prefix or something, e.g. It grabs all the tables with PBI_ as a prefix.
I am happy for any ideas for a solution, e.g. either scripting it into the Power BI Desktop or doing it programatically through the apis, but the dataset creation needs to be able to handle tables that are named differently in each database but can have a common prefix.
Thanks in advance for your help.
Solved! Go to Solution.
You can create the Role-level-security and configure it on your dataset so that you can set restriction on the group users. For more details, please refer to doc below:
https://docs.microsoft.com/en-us/power-bi/service-admin-rls
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You can create the Role-level-security and configure it on your dataset so that you can set restriction on the group users. For more details, please refer to doc below:
https://docs.microsoft.com/en-us/power-bi/service-admin-rls
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |