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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Salesforce Reports Dataset Refresh - Error 400

Hey Guys, 

 

I've created a report that pulls in data from an existing SFDC report.  In the desktop version of Power BI, I'm able to connect and refresh with no issues.  I'm also able to publish the report without any issues.  It's exactly what I need.

 

The issue comes in when I try to schedule a refresh on the deployed dataset.  I have found that the credentials need to be re-entered upon publishing my dataset.  When I do this, I am able to see that the OAUTH is established in SFDC for my Power BI Refresh successfully; however, I receive this error and am not able to save or move forward with refreshing. 

 

error.PNGoauth.PNG

The only way I've been successful at refreshing the dataset is to refresh it using Power BI Desktop and re-publishing the dataset.

 

One thing that I noticed is that I am able to create a new report and refresh its dataset directly from Power BI Online; however, I run into issues using a published dataset.  I need to use my published dataset, which simply connects to one report from SFDC.

 

Here is the dataset datasource settings.

 

dataset.PNG

 

I'm at a loss, and any help would be very much appreciated.  If more details would be helpful, just ask.

Thanks guys!

Status: Accepted
Comments
xerxel
Advocate II

Are custom SFDC URLs supported now?

heflore
New Member

Wanted to see if I get can an update on this issue. I am also getting the same issue. Please let me know in what way I can help solve this issue. 


heflore
New Member

Wanted to see if I get can an update on this issue. I am also getting the same issue. Please let me know in what way I can help solve this issue. 


v-qiuyu-msft
Community Support

Hi all,

 

I got information that it works if the account is an saleforce developer account. Please check which kind of Salesforce do you use? Thanks. 

 

Best Regards,
Qiuyun Yu

v-qiuyu-msft
Community Support

Hi all, 

 

Would you please check if you are using saleforce developer account? 

 

Best Regards,
Qiuyun Yu