PowerBI Deploy Management

[stefanik]

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

[V-lianl-msft]

Hi @stefanik ,

Based on your description, reports are created based on different data sources.

I haven't tried what you said. See if this can help you:

https://docs.microsoft.com/en-us/power-bi/developer/automation/configure-credentials?tabs=sdk3 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[stefanik]

Hi Liang,

thanks for your time.

I already seen that docs but they always refer to some Gateway and i wasn't able to correctly run the the provided code. It seems that the signature of some methods are changed!

When I publish a new report into a powerbi service workspace, if not already present, a gateway are automatically created and binded to the dataset inside the report?

If yes, the discover api has to return it's id, right?

[stefanik · Accepted solution]

I found the answer in this thread:

https://community.powerbi.com/t5/Service/Dataset-refresh-error-Service-principal/td-p/1078969

Thx all

Special thx to @Jayendran and  @v-deddai1-msft