I'm trying to deploy slight variation of a
dashboard report, to show different client a slice of their data (and not of their competition). For that, I built a base report (hereafter, my template). Using the REST API, I then clone that template, create a new dataset and push the data I want that client to see, then rebind the cloned dashboard to the new dataset. So far so good.
The problem is that in the process, any calculated column / table / measure get wiped out. I would have assumed that the calculated table / columns were a property of the
dashboard report, not the dataset.
Anything I can do? Should I be doing what I'm doing (automatically deploying a template with different dataset) some other way?
(edit: changed dashboard to report for clarity. Thanks Quentin)
Calculated columns are a property from reports, not dashboard. (Dashboard are built from reports.)
What you can do is create a dynamic page that would be filtered with your client id via drillthrough
You would only have to build one page based on a primary one.
There is a great example of what drillthrough looks like here : https://www.blue-granite.com/blog/create-a-dynamic-title-in-power-bi
Don't mind about her example, look at the powerbi reprot and right click on a breed > drillthrough > breed info