Forum Discussion
drrai66
Resolver I
8 years agoReplacing a Datsource in a Report
Hi Experts, I have a report which I created from the datadump in excel stored on my computer. Now in order to make the report dynamic, I want to connect it directly to the my DB and replace the exi...
- 8 years ago
Hi drrai66,
You can try it:
Create a separated PBIX getting the data from the DB;
Click on "Advanced Editor" on "Edit Queries";
Copy the steps where it connects to the database;
Go to your original report, click in "Edit Queries" -> "Advanced Editor" and replace the source.
There is a reference here:
ricardocamargos
Continued Contributor
8 years agoHi drrai66,
You can try it:
Create a separated PBIX getting the data from the DB;
Click on "Advanced Editor" on "Edit Queries";
Copy the steps where it connects to the database;
Go to your original report, click in "Edit Queries" -> "Advanced Editor" and replace the source.
There is a reference here: