I would like to know how to share my report with co-workers with edit access? They should also refresh data and basically have all access to modify. We are already working with the source files in the sharepoint which is commonly shared.
So, Can I say that person who is creating the model can only edit and do the calculation and the people to whom the data is shared can only modify the dashboards but cannot edit the queries??? Is my understanding correct?
or in other words, Is it not possible to someone to add data to an excel sheet in sharepoint and then refresh the data that others have created? Hope it throws error too or will it actually work?
That is correct that currently only one person can create the model and edit the queries. Unless you send the PBIX file to another person who makes some changes and uploads it into the same App Workspace. But that still means that only one person can edit and make changes at a time.
If your source data is from Excel in SharePoint and you are using the Gateway to refresh the data, then the data will be refreshed based on your Gateway schedule that you have created.
Unless I do not understand your question correctly?
Did I answer your question? Mark my post as a solution!