Forum Discussion

stefanik's avatar
stefanik
Helper I
6 years ago
Solved

PowerBI Deploy Management

Hi All,

i need some suggestions in order to find a way to manage the deploy phase of multiple pbix files into powerbi service.

 

My scenario is this:

1) i've created a pbix file that has many ApplicationInsigthts query (imported as blank query so i need to refresh them periodically from power bi service)

2) i've created parameters for the blank query that host applicationid, apikey and tenant name of the specific customer

 

At this point i have to publish the report in 1) for each customer into powerbi service (maybe 20-30). 

I figured this scenario:

 

3) i have to create a ps script to copy and rename the file in 1)

4) with power bi api i can publish each pbix file

5) with power bi api i can change the report parameters accondigly to the specific customer

6) with power bi api i can trigger a "first refresh"

 

At this point if i add a new tab into the main report, running 3-6 steps i can change all the customers report at the same time.

 

The only dowell that it is missed from this puzzle is that i have to specify the datasource credential of each report in powerbi service:

is there a way to specify the credential with powerbi api ( or in some automated way), or i have to rethink the entire structure?

 

Thanks

s

 

 

 

3 Replies