Salesforce Reports Dataset Refresh - Error 400

[chrismazur]

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. 

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.

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

Thanks guys!

[chrismazur]

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. 

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.

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

Thanks guys!

[chrismazur]

*

[v-qiuyu-msft]

Hi @chrismazur,

I can reproduce the issue. And already reported it internally. Will update here once get feedback.

Best Regards,
Qiuyun Yu

[v-qiuyu-msft]

Hi @chrismazur,

The same issue already reported: CRI 38910695. If there is a update about this issue, will let you know as soon as possible.

Best Regards,
Qiuyun Yu

[v-qiuyu-msft]

Hi @chrismazur,

Please try again to edit Salesforce data source in service.

If issue persist, please share Request ID here.

Best Regards,
Qiuyun Yu

[chrismazur]

It failed again.  The Request ID is:  

08899181-3abe-7e2b-121b-2d704389f5ff

[v-qiuyu-msft]

I have sent this information internally, will update to you once get feedback.

Best Regards,
Qiuyun Yu

[chrismazur]

@v-qiuyu-msft, any updates to share?

[chrismazur]

This is becoming a real issue for us.  Any ideas on when this may be addressed?