CODEWITHSUNDEEP
powerbi
Techchamp Pgm
Techchamp Pgm

Reputation: 159

are datasets confined to power bi service

I tried to find information about datasets in power BI, and it looks like the concept of datasets comes in Power BI Service environment only; to confirm my understanding, I tried to find information on google : "datasets in power BI desktop" which again gave me datasets in power BI service.

I am relatively a new learner of Power BI, and hence my question would be a basic one.

Would anyone please comment on my understanding; Thank you for giving your valuable time.

Upvotes: 0

Views: 121

Answers (2)

Jon
Jon

Reputation: 4967

When you create a report in PBI Desktop, you are creating a data model. This data model will hold everything for that report.

When you deploy the report to the service, it splits out that file into its two elements, a dataset as seen in the dataset tab that hold the information (based on the data model), and reports, that hold the visuals.

Once in the service, you can share that dataset, build new reports from it in the service, or link PBI Desktop to the dataset in the service. This allows you to create multiple variations of reports from the same dataset, that reduces data duplication in the service, saves space, and when you have to update the data model or reports makes it a bit easier. More info on sharing datasets across the organisation is here.

Datasets are confined to the service and there are two main ways of getting the data, connecting PBI desktop to the dataset, or using Analyze in Excel. Best practice is that you use PBI as a data analysis and consumption layer, not as a data source in itself, for example, extracting the data from the data set to another data source for further transformation.

Upvotes: 1

Mr Robot
Mr Robot

Reputation: 322

Once you create power bi dashboard from power bi desktop app you need to publish to the tenant. That power bi .pbix file deployed as report and dataset file.

Report : Your implementations deployed as report. Dataset : Dataset related to the published dashboard.

Once you installed gateway you can sync dataset with your datasource

Upvotes: 0

Related Questions