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

Helpful resources

Announcements
Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 355 members 3,564 guests
Please welcome our newest community members: