Forum Discussion

tpeppard's avatar
tpeppard
Regular Visitor
7 years ago
Solved

Changing Database for a Dataset on a Published Report

Is it possible to change the Database that a Dataset is using for a Published Report?   If we develop a report, we may develop this against a database called ‘CLIENT1_DEV’. This server will be on o...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi tpeppard

    Do you connect to SQL server or SSAS or other datasoucers? which connection mode is it?

    Based on my understanding, a database called ‘CLIENT1_DEV’ is under the server called 'DEVSERVER1'.

    After you publish the report (which uses data from database called ‘CLIENT1_DEV’)  from power bi desktop to service, you want to change the database used in the report from ‘CLIENT1_DEV’ to another database).

    Is my understanding right?

     

    If so, please read this article to have a try. One thing to take note of, is that this currently only works on Imported data sources and not DirectQuery or LiveConnection.

    Using the Power BI Service Parameters to change connection strings (To possibly change between Dev, Test & Prod)

     

     

    Best Regards

    Maggie

     

     

     

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi tpeppard

Do you connect to SQL server or SSAS or other datasoucers? which connection mode is it?

Based on my understanding, a database called ‘CLIENT1_DEV’ is under the server called 'DEVSERVER1'.

After you publish the report (which uses data from database called ‘CLIENT1_DEV’)  from power bi desktop to service, you want to change the database used in the report from ‘CLIENT1_DEV’ to another database).

Is my understanding right?

 

If so, please read this article to have a try. One thing to take note of, is that this currently only works on Imported data sources and not DirectQuery or LiveConnection.

Using the Power BI Service Parameters to change connection strings (To possibly change between Dev, Test & Prod)

 

 

Best Regards

Maggie

 

 

 

DeborahPerreaul's avatar
DeborahPerreaul
New Member
7 years ago

Carolina scored three runs in the bottom [url=https://url4.org/w2axp]grademiners[/url] of the second inning to take a 3-1 lead. Dustin Houle hit an RBI single to tie the game, and Devin Hairston connected with an RBI double to give the Mudcats the lead. Ryan Aguilar scored on a wild pitch later in the inning.