Forum Discussion

Krunalbpatel's avatar
Krunalbpatel
Helper III
9 years ago
Solved

Change Published report data's Dynamically

Hi,   I have Prepare a report In Power BI Desktop using my Local Database(Local Server) and Published that report to Power BI Account. Its working fine for me. Now I want to use this same report fo...
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi Krunalbpatel,

     

    If you are satisfied with the answer, would you please mark the helpful reply as an answer, so that we can close this thread? 

     

    Best Regards,
    Qiuyun Yu

ankitpatira's avatar
ankitpatira
Community Champion
9 years ago

Krunalbpatel You can explore the possibility of using power bi rest apis using which you maybe able to to change dataset connection strings.

 

Other option i can think of is if your data source is sql server then write sql query to import data from both the database. For example

 

Select *, 'Prd' as [database] from table1

union 

Select *, 'QA' as [database] from table2

 

Then use slicer to differentiate on data between two databases. When published to power bi service this will work.

Krunalbpatel's avatar
Krunalbpatel
Helper III
9 years ago

ankitpatira No I think the option provide by you Is not my solution, can you please provide basic ideas related rest APIs or Any reference link to me?