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!

Petebro's avatar
Petebro
Microsoft Employee
5 years ago

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

 

  • 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.