Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingYou'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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingSo 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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThank you very much for answering.