Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
@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
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?
@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
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.
@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
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).
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |