cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
BDA2 Member
Member

PowerBI connect Salesforce Report Refresh Failure (Intermittent)

I recently gotten a failure notice when I refresh Salesforce Report with PowerBI desktop. It happens at intermittent, sometimes ask for login sometimes won't. Even if inputted my credentials, the login will keep asking again for my login credentials.

 

Previously this does not happen, only until recently which is annoying.

 

  1. I checked my Salesforce Edition is unlimted , API still has lotsa bandwith
  2. My Salesforce user profile is not clone.
  3. I had done the data source setting to edit every permission 'Public"

Can someone suggest or advise alternative solution ?

 

 

 

Many ThanksIntermittent Refresh Failure PowerBI.jpg

 

5 REPLIES 5
Moderator v-yuezhe-msft
Moderator

Re: PowerBI connect Salesforce Report Refresh Failure (Intermittent)

@BDA2,

What version of Power BI Desktop do you use? Does your salesforce password expire? I would recommend you change your password and check if the issue still occurs.

Also please ensure that  you disable Force relogin after Login-As-User setting in salesforce.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
BDA2 Member
Member

Re: PowerBI connect Salesforce Report Refresh Failure (Intermittent)

Hi @v-yuezhe-msft

 

My PowerBI Desktop version is : Version: 2.59.5135.781 64-bit (June 2018)

 

My salesforce password does not expire. Every quarter we are required to change our login password.

I just changed mine.

 

Login directly into Salesforce or get data as online source Salesforce Report dont have this issue, only when performing refresh  have this issue.

 

I will check if Force relogin was enabled. If this is not enabled.

 

Can you advised what are the root cause may cause this problem ? 

BDA2 Member
Member

Re: PowerBI connect Salesforce Report Refresh Failure (Intermittent)

Hi @v-yuezhe-msft

 

My PowerBI Desktop version is : Version: 2.59.5135.781 64-bit (June 2018)

 

My salesforce password does not expire. Every quarter we are required to change our login password.

I just changed mine.

 

Login directly into Salesforce or get data as online source Salesforce Report dont have this issue, only when performing refresh  have this issue.

 

I will check if Force relogin was enabled. If this is not enabled.

 

tessa_luna Frequent Visitor
Frequent Visitor

Re: PowerBI connect Salesforce Report Refresh Failure (Intermittent)

Did you finda solution? im at the same situation

BDA2 Member
Member

Re: PowerBI connect Salesforce Report Refresh Failure (Intermittent)

Nope no solution temporary.

Still working with Salesforce Team.

 

According to them the only way is to change report refresh API to synchronouus to asynchronous.