Tablix error

[PeterWW]

I am getting this error when I add more than 1 dataset to a report in paginated report builder.

The tablix 'Tablix3' is invalid. The value for the DataSetName property is missing.
----------------------------
The definition of the report '' is invalid.
----------------------------
An error occurred during local report processing.

[Alan_]

For anyone else out there I had the same issue. I used a tablix as a header and had not linked it to a dataset of which i have two in my report. The reason for this is because a tablix as a page break attribute. 

It is a simple fix, add a data field to the table, then remove it and no more error since the table is then attached to a dataset

[v-luwang-msft]

Hi @PeterWW  ，

Has your problem been solved, if so, please consider Accept a correct reply as the solution to help others find it.

Best Regard

Lucien Wang

[PeterWW]

Thanks Lucien, the link didn't help but it is now solved

[suthesan]

how did you solve? 

[v-luwang-msft]

Hi @PeterWW 

Paginated report allow more then one dateset to create a report. Since your specific problem cannot be determined, you can refer to the video below to do so.

Power BI Paginated Reports Tutorial - Join data from different datasets in a report table：https://www.youtube.com/watch?v=HX7vkCAeDZU

Wish  it is helpful for you!

Best Regard

Lucien Wang

[amitchandak]

@PeterWW , Not excat same. But see if this can help

http://www.sqlandssrssolutions.com/2013/10/the-tablix-is-invalid-dataset-property.html

[PeterWW]

Thank you but as you say this is different from my problem. I have 2 datasets in my report