cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
eprochasson Frequent Visitor
Frequent Visitor

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

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)

 

 

1 REPLY 1
quentin_vigne Senior Member
Senior Member

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

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