Forum Discussion

AnotherBIUser's avatar
AnotherBIUser
Icon for Helper I rankHelper I
2 years ago
Solved

Missing Column in PowerBI Service vs PowerBI Desktop Refresh

Hello,   I am attempting to refresh a salesforce object that I have pulled into my data model. When I refresh on desktop I receive no error, but when I attempt to refresh on service I receive the e...
Need Help
  • AnotherBIUser's avatar
    AnotherBIUser
    2 years ago

    Found a solution. Not sure why it worked. Here's to anyone who finds this thread in the future.

    1) Refresh on desktop

    2) Go to Service and re-enter the salesforce login credentials in the "Data Source Credentials" under the Semantic model 

    3) Publish from desktop to service 

    This resloved the issue once Service refreshed the model. From what I can gather the issue is not actually with the tables, but rather with the access/login. 

AnotherBIUser's avatar
AnotherBIUser
Icon for Helper I rankHelper I
2 years ago

I have also cleared my Desktop Cashe, refreshed the dashboard, published then refreshed on service with no result.

  • AnotherBIUser's avatar
    AnotherBIUser
    Icon for Helper I rankHelper I
    2 years ago

    Now here is where it gets strange. I went ahead and loaded the Opportunity table into its own PowerBI dashboard, no visuals etc. Published it, refreshed on service with the same login info, and it refreshed fine. The Opportunity table in the new query INCLUDES the Lean__Data_Routing_Action__c field.