Forum Discussion

lbarreiro's avatar
lbarreiro
Regular Visitor
8 years ago

modify a published report

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 publis...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

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's avatar
lbarreiro
Regular Visitor
8 years ago

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? 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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's avatar
      lbarreiro
      Regular Visitor
      8 years ago

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        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