cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper IV
Helper IV

How to connect a report to an existing database?

Hey there,

 

I have 2 reports connected to 2 separata detabases (which are identical), is it possible to connect the two reports to the same database instead. I find it a bit redundant to have two automatic refresheshes instead of one and so on. 

AndrejBI_0-1604053398795.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
Memorable Member
Memorable Member

@AndrejBI  you can make use of shared dataset with which you need to refresh only maindataset.For this to work you need to connect to Power bi dataset which inturn will live connect to dataset which are available in your workspaces.

Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.


Appreciate your Kudos, Press the thumbs up button!!👍




View solution in original post

4 REPLIES 4
Super User III
Super User III

Hi @AndrejBI 

 

you can link multiple reports into a single dataset, that way you refresh only once.

Please refer to the below article by Matt Allington
https://exceleratorbi.com.au/new-power-bi-reports-golden-dataset/ 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

Memorable Member
Memorable Member

@AndrejBI  you can make use of shared dataset with which you need to refresh only maindataset.For this to work you need to connect to Power bi dataset which inturn will live connect to dataset which are available in your workspaces.

Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.


Appreciate your Kudos, Press the thumbs up button!!👍




View solution in original post

Thanks @HusnaBanu413

 

This works, yet it creates a new report. I need to connect the existant report, as many users have access to that one, and I don't want to notify them about the change or anything along the lines. Do you know how to transfer the existant report, so it's connected to the old database? The link should not be changed. 

@AndrejBI what i understood here is you have 2 reports from the same source  ....you want to change the datasource source setting of the second report and connect to the database as that of  the first report all this is possible in power bi deskop only and you will have to republish the file again....

You can edit the source settings from power query select the table and click on advance editor change the source path and close and apply the settings 
datasource1.png

Home Tab-->Transform data-->Datasource setting delete the database which you do not want it 


DATASOURCE2.png


Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.


Appreciate your Kudos, Press the thumbs up button!!👍



 

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors