Forum Discussion
Team collaboration // Desktop & Service
Hi All!
Is it possibile to modify report and dashbaord uploaded into the working area service?
I need to create new measures but it seems I can only modify panel layout from there.
Do I need to download my report, modify it with PowerBI Desktop and the upload it again in the working area?
I need to work and colalborate with my team-mates and I am looking for a solution for using and sharing the same file
Thank you in advance!
Hi Liv
Yes, you need to download the pbix file to your local computer and add new measures with Power BI Desktop. Then publish the new pbix file into the same workspace in Power BI Service to replace the old dataset and report. This is because measures are created in the model (we call it as dataset in Power BI Service). However in Power BI Service, it doesn't allow us to edit a dataset.
One exception is that you can use the method introduced in this video (Deploy Power BI dataset schema changes WITHOUT refreshing! - YouTube) to deploy only metadata (including the new measures) to the dataset in Power BI Service without refreshing the data. It uses an external tool ALM Toolkit and connects to the dataset through XMLA endpoints. This is a Premium feature which is only available in a Premium Per User workspace or Premium Per Capacity workspace. And one important thing to consider is that you can no longer download the PBIX file from the service after you deploy the change. This cannot be reversed back. So if you want to use this method, please confirm that you are very clear what will happen after the operation and have much experience in this. Otherwise I recommend that you download the pbix file to modify it and publish it again to bring in the new changes. This will be much safer. You can make copies of reports easily.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
1 Reply
v-jingzhangCommunity Support
Hi Liv
Yes, you need to download the pbix file to your local computer and add new measures with Power BI Desktop. Then publish the new pbix file into the same workspace in Power BI Service to replace the old dataset and report. This is because measures are created in the model (we call it as dataset in Power BI Service). However in Power BI Service, it doesn't allow us to edit a dataset.
One exception is that you can use the method introduced in this video (Deploy Power BI dataset schema changes WITHOUT refreshing! - YouTube) to deploy only metadata (including the new measures) to the dataset in Power BI Service without refreshing the data. It uses an external tool ALM Toolkit and connects to the dataset through XMLA endpoints. This is a Premium feature which is only available in a Premium Per User workspace or Premium Per Capacity workspace. And one important thing to consider is that you can no longer download the PBIX file from the service after you deploy the change. This cannot be reversed back. So if you want to use this method, please confirm that you are very clear what will happen after the operation and have much experience in this. Otherwise I recommend that you download the pbix file to modify it and publish it again to bring in the new changes. This will be much safer. You can make copies of reports easily.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.