I am working on a project to embed a report in a website. Our report has a dataset that connects to another dataset via direct query. The Report Dataset containts measures and some DAX defined tables for filtering and ranking and the PBI Datasets contain all the data.
Currently, when I do dynamic binding, it binds the report to the PBI Datasets and doesn't use the Report Dataset. This breaks my report because the measures aren't included.
How do I do dynamic report binding with linked datasets?
