Export data from table visualization to another Power BI as a table

[Pelahibdo]

Hi,

I have a table visualization with data from multiple tables. I want to export the data and import it to another BI report. Is there any other way than export in excel and import it?

Thanks,

[siraju · Accepted solution]

To transfer data from one Power BI report to another without exporting it to Excel, you can use dataflows or shared datasets. These methods allow you to share and reuse data efficiently across different reports without manually exporting and importing files.

1. Shared Datasets: You can publish a dataset to the Power BI service and reuse it in multiple reports. By publishing the dataset once, other users or reports can connect to it. This approach centralizes your data and avoids redundant imports.

2. Dataflows: Dataflows enable you to prepare and transform data that can be reused in multiple Power BI reports. By creating a dataflow, you define reusable transformation logic, which can be consumed by other reports in the service. This is particularly useful when you have data coming from multiple sources or need to apply ETL logic.

For more details, check out the official Microsoft documentation on sharing dataflows and shared datasets.

[audreygerred]

You can just use your semantic model that is published in service as the source in the new report. Click get data, select Power BI semantic model and then you can work with the data in a new report. Set page or report level filters to limit the data if you want it to match what was returned in your table in the other report.

[Pelahibdo]

Thanks,

Just to confirm: that would need to publish the report on the BI online?