Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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 |
| |
Time: | 2018-08-02 16:33:56Z |
Solved! Go to Solution.
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.
@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
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.
@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
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.
Do you refresh successfully if you filter column "Owner_Profile__c" after merging tables?
Regards,
Lydia
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.
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.