Forum Discussion
Opening Report in Desktop
Correct. Without Edit (or Admin) permission, you can only view in Power BI Service.
I'd like this ability as well. I'm using a deployment pipeline. I'd like to be able to open a PBIX from the test environment, edit it in Power BI desktop, and save it back to test. I don't want to have to maintain a copy somewhere else and then publish it to test. Maybe this isn't best practice?
There are limitations being able to export PBIXs from service--so I think you're better off maintaining your PBIX in a local folder (or OneDrive for version control) and then publishing to service.
https://docs.microsoft.com/en-us/power-bi/create-reports/service-export-to-pbix#limitations
Especially if you're using Deployment Pipelines. I maintain my DEVELOPMENT version PBIX, and then publish to the DEVELOPMENT Workspace in my deployment pipeline. I use a Parameter in my dataset "IsDevMode" that when True only loads 10 records from my data source to keep my PBIX small to store and fast to import. When promoting to TEST, a rule changes this to False to import all the data.
#"Kept First Rows if IsDevMode" = if IsDevMode then Table.FirstN(Source, 10) else Source,I use a simlar appraoch with RLS data--a "IsRLSEnabled" Parameter and rule to only Import all the RLS data when promoting to PRODUCTION.
Obviously, all this can be configurable.