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

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

joansinho's avatar
joansinho
Advocate I
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. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    joansinho,

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


    Regards,
    Lydia

    • joansinho's avatar
      joansinho
      Advocate I
      7 years ago

      Anonymous

       

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        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