ETL in PBI Flashcards
What is the difference between a data source and a semantic model (dataset)?
Data source is the original source of the data while a semantic model (dataset) is the container that hold this data and information about the data source (e.g. credentials).
What could happen if I change the location of a flat file used as data source for my report?
Connection to data source will be broken and I will no longer be able to fetch data from the source
How can I update the location of a data source used in my report?
File > Options and settings > Data source settings
What is the relation between a dataset and a semantic model?
They are the same thing. Microsoft has renamed the term dataset to semantic model.
What is the Build Permission feature?
Feature that allows owners of a semantic model to control which users can have access to it, effectively determining who can use it on their reports.
What are the differences between local and shared semantic models (datasets)?
Main differences are related to:
* Location: local datasets are stored locally while shared ones are stored in cloud platforms (Power BI service) or multiple locations
* Accessibility: local datasets are accessibile to invidiuals or a specific organization while shared ones are available to multiple users across multiple organizations
What are the factors to have in mind when choosing between local and shared semantic models?
Data Control: Both types allow control over who can access the dataset. However, local datasets have the tighter control since data cannot be shared across organizations. Share datasets require additional considerations regarding data governance to avoid inappropriate sharing of data between workspaces
Speed: Having local datasets offer some gain in terms of speed when comparing having to go to the cloud to fetch data in shared datasets.
Collaboration: only one user can work on the dataset at a time, while shared datasets allow multiple user to access and modify the same dataset.
