Forum Discussion

joansinho's avatar
joansinho
Advocate I
8 years ago
Solved

Refresh Failed

Hi,

I am getting this error everytime I am trying to refresh my data. I use SF to connect my data to PowerBI. I am new in PowerBI, and I am trying to figure out a way to avoid this error.

 

"Power BI

The last refresh failed: Thu Aug 02 2018 12:33:56 GMT-0400 (Eastern Daylight Time)
There was an error when processing the data in the dataset. Hide details
Data source error:(Owner_Profile__c='Evaluator User') AND TRUE ^ ERROR at Row:1:Column:368 unexpected token: 'TRUE'. The exception was raised by the IDataReader interface. Table: Submission Feedback.
 Request ID
1c6661de-ea09-357f-8ddb-5a0a1d57aa52
Time:2018-08-02 16:33:56Z
"
  • joansinho's avatar
    joansinho
    8 years ago

    Anonymous

     

    I have checked, and I do have the right permission. This table contains hundreds of rows. I am merging this table with another table, and I believe the reason I am getting this error is that besides the unique id there is no other information on the other columns. Before merging the tables, I filter the column "Owner_Profile__c" so it only shows "Evaluator User''. Since there is not "Evaluator User" in the column, I am guessing that's why I am getting that error. 

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    joansinho,

    Are you able to refresh the data in Power BI Desktop? Have you checked that if  there are any issues in Submission Feedback table?

    Regards,
    Lydia

    • joansinho's avatar
      joansinho
      Advocate I
      8 years ago

      Anonymous

      I am not able to refresh the data in Power BI Desktop. I received the same error as above. I have checked the table, and I don't see any issues there.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        joansinho,

        Could you please check if you have appropriate permission on this table? And how many rows in this table? What operations do you take for this table in Power BI Desktop?

        Regards,
        Lydia