Cloning and rebinding a report to a dataset kills calculated table / columns / measure

[eprochasson]

Hi,

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?

Thanks!

(edit: changed dashboard to report for clarity. Thanks Quentin)

[piper]

Hi @eprochasson,

Were you able to solve this some how?

Currently, since a week I am trying to figure out workaround for this.

[quentin_vigne]

Hi @eprochasson

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

- Quentin