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.
Hey Everyone,
My question relates specifically to datasets and how/if they are cached/copied in different locations. Sorry if this seems confusing I am having trouble understanding and appreciate any insight. I will try to clarify as best I can.
My goal is to limit the number of dataset numbers growing if many users access the same dataset across different workspaces using shared datasets (and workspaces in Premium capacities). Also, I aim to export data to Power BI desktop users while importing data from SSAS.
So it is my understanding that when a Power BI Report is created in the Desktop App (.pbix file) and assuming the connection mode is import data, the report is two components. The report is the visualization layer and the dataset includes the data, tables, relationships etc. (seen as hosted through Analysis Services Engine).
After I publish the .pbix report to the Power BI service, is the dataset copied and now resides in the Power BI service Workspace? If so, and I pull the dataset (using get data on the Desktop App), make changes, and republish, does the dataset copy into a new dataset? How are datasets cached in the Power BI service? Is there ever an instance where a change in report or dataset (remember using import mode) copies the dataset and increases the dataset number in the workspace?
Thank you!
-SBeat
Solved! Go to Solution.
@Anonymous -
Bottom line: There are many options and all organizations should have a governance plan in place to plan out the access, processes, roles, responsibilities and training involved with using Power BI.
@Anonymous -
When users connect to a Dataset as a source, it's a Live Connection. No copy of the dataset is made.
Anybody with certain Workspace Access is able to edit the dataset, so controlling access is important.
Since you don't want these report developers to have access to the workspace, you can give access to the dataset through Publishing the App.
@Anonymous -
Bottom line: There are many options and all organizations should have a governance plan in place to plan out the access, processes, roles, responsibilities and training involved with using Power BI.
Thank you @Anonymous for clarifying the datasets. Data governance and ETL is indeed my focus during my research.
Allow me to provide a security scenario. I want to upload a shared dataset into a Premium workspace from a SSAS Server using import mode. I want this to be my single point of truth (SPOT). I will have one report writer upload this but have many other users (with either edit or read-only access) "get data" from this shared dataset. Based on your answers earlier can I:
I am guessing this is where security measures i.e. roles, access, etc. come into play. Is there a way to configure governance to prevent my SPOT dataset from being changed using import mode?
Thanks again!
@Anonymous -
When users connect to a Dataset as a source, it's a Live Connection. No copy of the dataset is made.
Anybody with certain Workspace Access is able to edit the dataset, so controlling access is important.
Since you don't want these report developers to have access to the workspace, you can give access to the dataset through Publishing the App.
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.