Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
Hi @eprochasson,
Were you able to solve this some how?
Currently, since a week I am trying to figure out workaround for this.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
25 | |
3 | |
2 | |
2 | |
2 |