Forum Discussion

drrai66's avatar
drrai66
Icon for Resolver I rankResolver I
8 years ago
Solved

Replacing 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...
  • ricardocamargos's avatar
    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:

    Change datasource in PBI