Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Single vs Multiple Dataset

Hi Expert,   in my company on PBI Service I can see tons of different workspaces with many reports, now almost all reports have a dedicated dataset.   Since there are a lot of dataset for which t...
Need Help
v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

Hi, Anonymous 

 

Here are the relationships with datasets, report and dashboards. You can also refer to the official document .

ONE dataset...

  • can be used over and over in one or in many workspaces.

  • can be used in many different reports.

  • Visualizations from that one dataset can display on many different dashboards.

ONE report...

  • is contained in a single workspace.

  • can be associated with multiple dashboards within that workspace. Tiles pinned from that one report can appear on multiple dashboards.

  • can be created using data from one dataset. Power BI Desktop can combine more than one data source into a single dataset in a report, and that report can be imported into Power BI.

ONE dashboard...

  • is associated with a single workspace

  • can display visualizations from many different datasets

  • can display visualizations from many different reports

  • can display visualizations pinned from other tools (for example, Excel)

I'd like to suggest you use dataflows if you are work with complex or larger projects. They're great for preparing data for use—and potential re-use—by your datasets. For more information, see the Self-service data prep in Power BI article and composite-models . 

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.