Syntax error missing operand value after operator s. when connecting to PBI dataset

[MVR01]

Hi all,

So i can make a connection to a Power BI dataset from Report Builder (datasource), but when i want to create a dateset and choose the query designer i get the error "Syntax error missing operand value after operator s."....what does this mean and more importantly how can i fix this? or is this a bug in report builder?

Thanks in advance for your answers!

Regards,

Marc

[MVR01 · Accepted solution]

Found it! when using an apostrophe in the name of a dimension or measure group in Power BI, Report builder will give an error when trying to create a dataset in report builder.