Forum Discussion

LynnG's avatar
LynnG
Frequent Visitor
5 years ago
Solved

Error Token Comma expected.

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 doe...
Error on Data load
Report Server
  • LynnG's avatar
    LynnG
    5 years ago

    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!

LynnG's avatar
LynnG
Frequent Visitor
5 years ago

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

Petebro's avatar
Petebro
Microsoft Employee
5 years ago

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.