Manage roles: issue that can only be solved by deleting complete source

[Anonymous]

Hello,

I have roles in my report. One source (file) has changed but that keeps on working fine. However, now I get a error message when I click on manage roles. Also, users get errors in PowerBI Service, probably because of the same error. The only way I seem to get it working again is to delete the whole source and set it up again. Any idea how to solve it easier?   See link for details of the error:

https://gofile.io/d/ld1d4z 

[v-zhenbw-msft]

Hi @Anonymous ,

What version of Desktop do you use?

Did it happen except you clicked the manage roles?

What data source do you connect? Is an import mode?

And I couldn’t download your pbix file, could you please upload it in OneDrive for business?

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Open Transform data/ edit query mode and check for detailed error. Share that.

refer how to handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTs

debug issue
https://www.youtube.com/watch?v=OE6DPmKqN7s

[Anonymous]

@amitchandak  there are no query errors so nothing visible that is going wrong when clicking on Transform Data. Just the error pop up when I click on manage roles.