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 all,
I have a few questions regarding dataset security in both service and desktop.
Thank you,
Dane
Solved! Go to Solution.
Hi @bolashd,
Generally, there are two main parts of Power BI. They are Power BI Desktop and Power BI Service. (We won't talk about Mobile and Embedded here).
Dataset only can be manipulated in Desktop. (Add calculated columns and measures.) Service is the powerful tool to share the work. We can create new reports with Service. But we can't change the dataset in Service. I think this suit the most needs.
So create a model with Desktop, then publish to Service. Power BI have several ways of sharing. I think the App workspace (preview) would be a good idea for your scenario. An app workspace contains all the things, including dashboards, reports, workbook, and dataset (can't be modified). We publish to the special audiences or the whole organization when we finish a prebuilt solution. We can add members who are going to customize the solution to the App and grant others read-only access. So one dashboard will be the prebuilt, users can built another one. Both the dashboard can share the same reports. Reference: powerbi-service-create-apps
A content-packs almost do the same thing of App workspace. If a user want to customize, the user have to make a copy.
I just post something most related to the scenario. There are more details. Please take these thing into consider: We can't manipulate dataset in the Service. If we want the user to customize the dataset, they also can change the whole dataset.
Best Regards!
Dale
Hi @bolashd,
Could you please mark the proper answer if it's convenient for you? That will be a help to others.
Best Regards!
Dale
Sure thing!
Sorry new to the community here. Thanks again for your help.
Hi Dane,
I think this is a big question. Many things are different between Desktop and Service in different scenarios. Let me try to answer it one by one.
1. Yes, there are.
1.1 In Power BI Service, we can't access the dataset directly and can't handle dataset (no writing). We can create reports and dashboards. There are several situations.
1). Share dashboard. Read only. No changes will be saved.
2). App workspace. Depends on settings.
3). Content pack. User can create their only copies.
4). Publish to web. Read only.
5). Etc.
In Power BI Desktop. User can access the data source can handle the dataset. If the dataset was already imported, people who get the file can handle.
1.2 Calculated columns only be create in Desktop.
2. It's hard to get this in one way.
This is just a little summary. It's complicated in different scenario and different settings. Could you please share your scenario? That would be easy to find a solution or a workaround?
Best Regards!
Dale
Hi Dale,
Thank you for the quick and thorough response.
Our scenario is as follows:
To summarize, we want our end users to be able to fully utilize Power BI for their adhoc reporting needs without changing the data structure or provided solutions.
As a potential solution, would it be possible to provide the data and prebuilt solutions (read-only access) through a Power BI app and the ability to create custume solutions within the same workspace?
Thanks again and I look forward to hearing from you.
-Dane
Hi @bolashd,
Generally, there are two main parts of Power BI. They are Power BI Desktop and Power BI Service. (We won't talk about Mobile and Embedded here).
Dataset only can be manipulated in Desktop. (Add calculated columns and measures.) Service is the powerful tool to share the work. We can create new reports with Service. But we can't change the dataset in Service. I think this suit the most needs.
So create a model with Desktop, then publish to Service. Power BI have several ways of sharing. I think the App workspace (preview) would be a good idea for your scenario. An app workspace contains all the things, including dashboards, reports, workbook, and dataset (can't be modified). We publish to the special audiences or the whole organization when we finish a prebuilt solution. We can add members who are going to customize the solution to the App and grant others read-only access. So one dashboard will be the prebuilt, users can built another one. Both the dashboard can share the same reports. Reference: powerbi-service-create-apps
A content-packs almost do the same thing of App workspace. If a user want to customize, the user have to make a copy.
I just post something most related to the scenario. There are more details. Please take these thing into consider: We can't manipulate dataset in the Service. If we want the user to customize the dataset, they also can change the whole dataset.
Best Regards!
Dale
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.