Refresh Failed

[joansinho]

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

"

[v-yuezhe-msft]

@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]

@v-yuezhe-msft

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.

[v-yuezhe-msft]

@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

[joansinho · Accepted solution]

@v-yuezhe-msft

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. 

[v-yuezhe-msft]

@joansinho,

Do you refresh successfully if you filter  column "Owner_Profile__c" after merging tables?


Regards,
Lydia

[joansinho]

@v-yuezhe-msft

Hi,

Yes, As long as there is data there I can refresh it without any problem. I just get that error when there is not data.

[v-yuezhe-msft]

@joansinho,

Exchanging the steps doesn't impact the final result, right? And are you able to refresh the data in Service this time?

Regards,
Lydia

[joansinho]

@v-yuezhe-msft

Exactly, And yes I am