Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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
tessa_luna
New Member

Did you finda solution? im at the same situation

Anonymous
Not applicable

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.

v-yuezhe-msft
Employee
Employee

@Anonymous,

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.
Anonymous
Not applicable

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.

 

Anonymous
Not applicable

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 ? 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors