Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
59 | |
32 | |
30 | |
29 | |
23 |
User | Count |
---|---|
48 | |
46 | |
23 | |
16 | |
14 |