PowerBI connect Salesforce Report Refresh Failure (Intermittent)

[Anonymous]

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 Thanks

[tessa_luna]

Did you finda solution? im at the same situation

[Anonymous]

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]

@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

[Anonymous]

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]

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 ?