modify a published report

[lbarreiro]

I have a report published in power bi.

I need to modify and to create measures, the only way of doing it is in power bi desktop? If I unload it and modify it in desktop, on having returned to publish it, it creates a new set of information and the programming update breaks.

There is way of doing it without this happens?

On the other hand, from power bi desktop, I can connect to the set of information the programming update is kept when it publishes, but I have to create the report from the beginning.

Someone could indicate me if there is another way of doing it?

Thank you!

[v-yuezhe-msft]

@lbarreiro，

You can download PBIX file from Power BI Service following the guide in this article, then modify the report, add measures and re-publish the PBIX file.

Regards,

Lydia

[lbarreiro]

Ok Lydia, but if the dataset comes from sql, when I publish the new report it creates a new dataset and I would have to reconnect the dataset with sql.  This always happen? 

[v-yuezhe-msft]

@lbarreiro,

After you download the PBIX file and modify it, you can publish it to Service and replace the existing dataset as other's post. What do you mean that reconnect the dataset with SQL?

Regards,
Lydia

[lbarreiro]

My dataset are connected with a sql database and have a schedule for automatic update. If I replace the dataset, it breaks this programming, and other reports that depend of replaced dataset  also would fail.

[v-yuezhe-msft]

@lbarreiro,

Temporarily turn off the schedule refresh option. After you modify the PBIX file and re-publish it, turn on the schedule refresh option.


Regards,
Lydia

[ausrine]

If I understood you correctly, you can modify it in Power BI Desktop and then publish it to the same workspace as before by replacing existing dataset with the one you modified (using the same dataset name).