Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Copy and Edit PBIX

Is there a way to program (or via a system like pipelines) a copy job, and then automatically edit the copied PBIX file to be set to a certain filter?
I have a PBIX which I distribute, but currently for every new version I have to manually copy and set the filter. It would save a lot of time if this can be done automatically. But I haven't found anything online. Could anyone help me?

1 ACCEPTED SOLUTION

No. Deployment Pipelines does not make any changes to the data. It accepts parameters to switch datasources if needed between dev/test/prod databases, but no report level changes are made. Whatever you publish in DEV is copied, AS IS, to the other environments.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

View solution in original post

4 REPLIES 4
edhans
Super User
Super User

You'd be delving way way deep into the undocumented JSON file that tells the report layer how to work. There is no documentation on that. You'd need to unzip the PBIX and play with that JSON, but I'd wager you will corrupt the file 999 times out of 1000 when trying this.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting
Anonymous
Not applicable

So the only way to do this is manually? Or could it perhaps be done through Deployment Pipeline in Power BI Service?

No. Deployment Pipelines does not make any changes to the data. It accepts parameters to switch datasources if needed between dev/test/prod databases, but no report level changes are made. Whatever you publish in DEV is copied, AS IS, to the other environments.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting
Anonymous
Not applicable

Thank you very much for answering.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors