How to export dashboard as pbix file or equivalent

[Anonymous]

Hi All,

I need help on how to move dashboards created in one account to another without using app workspace concept.

For Example:

Account Name: Development

Reports Involved: Sales Report, Inventory Report

Dashboard Name: Sales vs Inventory Dashboard

- In dev environment I have created two reports as mentioned above from two different datasets

- Created a dashboard "Sales vs Inventory Dashboard" which has tiles from both the reports

- Now i want to move this reports and dashboards to testing environment ( i.e.) another pbi account with name testing)

- I know reports can be moved by using pbix file, But how can we move the dashboard created????

- Do we need to recreate them or any other alternate method is available to do this?

- I mainly want to do like this because my dev account gateway is connected to dev database and testing account gateway is    connected to testing database and i dont have access to testing account

Additional Question:

Can we change the dataset of a report?

Thanks,

Dinesh J

[v-qiuyu-msft · Accepted solution]

Hi @Anonymous,

If you keep the reports and dashboards on test Power BI service and dev database contains the same data as test database, the easy way is to share a report/dashboard from test Power BI to dev Power BI.

As dashboard is created from reports, it doesn't have its own "file" as the report. If the share report/dashboard feature above doesn't meet your requirement, you need to publish the pbix file to dev Power BI, then pin report visuals to create a new dashboard. To ensure the report/dashboard gets updated data, you need to configure the dataset to use gateway to do refresh. 

To change dataset of the report, we need to open the report in Power BI desktop, then go to Data Source Settings-> Change Source. 

Best Regards,
Qiuyun Yu 

[Anonymous]

Hi @v-qiuyu-msft thanks for the replay, Now i'm clear with the dashboard exporting part

- We can share the dashboard or re-create it

But little confused in the dataset remapping part :

More explanation :

- I have a report A with dataset A

- I have one more report B with dataset B

- Both dataset A and B has same data

- Now i want to make the  report B to point to dataset A, Is this possible ?

- If i can achieve this i can delete the dataset B and save some space

Thanks,

Dinesh J

[v-qiuyu-msft]

Hi @Anonymous,

We can't rematch the published report and dataset on Power BI service currently. We need to modify the data source in report via Power BI desktop. 

Best Regards,
Qiuyun Yu