Missing Column in PowerBI Service vs PowerBI Desktop Refresh

[AnotherBIUser]

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 error that there are columns missing: 

Pulling just the Opportunity table in a seperate query shows that the object contains the Lean__Data_Routing_Action__c field.

Things I have tried:

1) Cleared out my browser cashe before Service refresh

2) Loaded and tested the same query in a different dashboard with the same result

3) Refresh the dashboard on Desktop, publish to service, then refresh on service. The service refresh fails. 

4) The suggestions in the following posts 

https://community.fabric.microsoft.com/t5/Service/The-HasUniqueRoleAssignments-column-does-not-exist...

https://community.fabric.microsoft.com/t5/Service/The-column-does-not-exist-in-the-rowset/td-p/32762...

Any assistance would be helpful.

Thanks!

[AnotherBIUser · Accepted solution]

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]

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

[AnotherBIUser]

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.