Forum Discussion
Power BI Report Migration among Tenants (Multiple reports on same dataset)
Super Useryou may be mixing up terminology here.
Dataset: collection of data sources and their relationships (aka data model)
Data Source: individual connection definition (also known as Query) that has its own credentials and source . A dataset can have multiple data sources.
Report: User Interface that accesses a dataset . Multiple reports can access the same dataset.
What you can't do is having a report point to multiple datasets. At least not yet. Might become possible with the composite data model that is promised for November.
hi lbendlin
for example i have 2 Reports named "Report 1" and "Report 2" pointing same dataset named "Report 1" in Source Tenant.
Is there a way i can export those and import in target tenant such that only one dataset named "Report 1" and 2 report pointing it exist?
- lbendlin
Again, terminology. "Tenant" means something different. Did you mean "workspace" ? You can move workspaces between capacities in a tenant. That would move the datasets and reports in a workspace to a new location (capacity). It's not helping you though if you want to copy reports between workspaces. For that you would need to export the .pbix from one workspace and then upload the report to the new workspace. If you have two reports pointing to the same dataset in the old workspace then I frankly don't know if you can even export the pbix for both.