Forum Discussion
TDS Endpoint multi value parameter PBRS
- 6 months ago
Hii lherbert501
The TDS endpoint expects strongly typed scalar parameters, so IN (@Team) or JSON parsing won’t work, which is why it throws “@Team was not supplied.”
Correct approach: Let Report Builder handle the multi-value expansion automatically by using:
t.name IN (@Team)Then ensure the parameter is configured as Multi-value and the dataset query type is Text (not stored procedure). Report Builder will internally expand it to multiple scalar parameters (@Team1, @Team2…).
If this still fails, the limitation is from the Dataverse TDS endpoint, which does not fully support multi-value parameterization in that case, you must switch to FetchXML or Power BI semantic model instead.
Hi lherbert501
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Thank you.