Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
30 | |
28 | |
23 | |
21 | |
18 |
User | Count |
---|---|
56 | |
37 | |
28 | |
24 | |
21 |