Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. 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.
User | Count |
---|---|
36 | |
31 | |
28 | |
25 | |
25 |
User | Count |
---|---|
52 | |
50 | |
37 | |
36 | |
30 |