topic Re: Error Token Comma expected. in Report Server

Error Token Comma expected.

LynnG — Mon, 01 Feb 2021 16:47:59 GMT

I am trying to connect to a table in SQL Server Database in our dwh and when I do GetData and select my table from the list, it displays and when I click Load I get Error Token Comma expected. It does not matter what table I select. When I try to connect in PBI desktop it works fine but not in PBI RS and I have tried multiple tables. Please HELP

Re: Error Token Comma expected.

Petebro — Mon, 01 Feb 2021 17:23:44 GMT

Hi,

Sorry to hear you're running into this.

Quick follow up question... the error "Token Comma expected" dialog does it show up in PBI RS portal when you try to render the pbix or does it show up in PBI RS Desktop?

We are trying to reproduce this error as we have not seen it before with SQL Server tables. Would you be able to share a PBIX report has similar behavior that doesn't contain private/sensitive information for you if we aren't able to reproduce it soon?

-Pete

Re: Error Token Comma expected.

LynnG — Mon, 01 Feb 2021 17:42:45 GMT

It shows up in RS Desktop when I try to GetData and select any table.

Re: Error Token Comma expected.

Petebro — Mon, 01 Feb 2021 17:39:58 GMT

Thanks for confirmation. Is there any chance there is a query text that is different between the two versions (the working report in PBI Desktop vs non working PBI RS Desktop)?

I'm not an expert in desktop but talking with a collegue it might be that the data is cached so it shows up in the Navigator (and says it was downloaded on friday) so when you load it's re-executing the query which has an error somewhere in it and thus pops up the error dialog.

Re: Error Token Comma expected.

josef78 — Mon, 01 Feb 2021 20:57:57 GMT

Hi LynnG,

please, after select table, try click on Transform data (instead Load data). It will open power query editor, and here please click on Advanced Editor in ribbon bat, and take screenshot of load script.

Re: Error Token Comma expected.

Anonymous — Wed, 03 Feb 2021 05:48:38 GMT

LynnG

Go transform data instead of load, and open advanced editor check the error. Basically, you are missing a comma in the code. See example:

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

Re: Error Token Comma expected.

LynnG — Mon, 08 Feb 2021 12:07:35 GMT

We figured it out by uninstalling and reinstalling the software which allowed me to access the permissions which were getting crossed with connections to my pbi desktop (not Report Server version). This has resolved the issue and thank you to all for your assistance!

Re: Error Token Comma expected.

LynnG — Mon, 08 Feb 2021 12:09:53 GMT

I could not even get that far... there was no query, I was connecting directly to the table in our data warehouse.

Re: Error Token Comma expected.

LynnG — Mon, 08 Feb 2021 12:12:06 GMT

I could not get to the part to select the table as it would not connect. No commas involved. But thank you for your response.

Re: Error Token Comma expected.

Anonymous — Mon, 28 Feb 2022 07:20:19 GMT

Hi lynnG

I have issue same with you, how to you can fix it ? pls help