Forum Discussion
Power BI Report Collaboration
A user shared workspace with me and i tried edit a report online ( Since i had to add a new sheet to existing report ) however i'm unable to add new datasource to it.
How can i go about it ?
Please note, i tried downloading PBIX file and adding new sheet with new datasource however it disrupted the old views when i published it back to the same workspace ( replaced the original report )
5 Replies
- Kedar_PandeSuper User
Ensure you have edit access to the workspace.
Download the file, modify it in Power BI Desktop by adding the data source.
Make sure existing visuals are not impacted by the new data.
Publish the modified report under a new name to avoid disrupting the original.- Garry030424Frequent Visitor
Kedar_Pande : I think that's a good approach to rename and publish , if everythings fine we could then overwrite the same report ? so that the end users don't need a change of links and stuff
- danextianSuper User
Hi Garry030424
Adding a new datasource is currently not supported in the service. Downloading the pbix and modifying it is what gets saved when published to the service, overriding the previous version. Look into using pbip for collaboration. https://learn.microsoft.com/en-us/power-bi/developer/projects/projects-overview
- Garry030424Frequent Visitor
danextian : Are you suggesting that i take PBIP file from that user then open and work in Power BI desktop and publish changes to same workspace.
And that this approach could possibly be better that PBIX approach ?
- AnonymousNot applicable
Hi Garry030424 ,
Yes, you can rename and publish the modified report first to make sure everything is fine before overwriting the original report. This way, end users don't need to change links or bookmarks, keeping their experience the same.
Best Regards,
Adamk KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.