News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) Can't Refresh Oppo...

Microsoft Dynamics CRM (Archived)

Can't Refresh Opportunity connection in Power BI

(0) Share

Report

Report

Posted on by ToniG

321

Hello all,

I've had a rough go since our update to 9.0 a week ago. Today I went to update some Power BI reports. I updated the connection to the version 9 environment, and I can refresh account, activity and lead queries, but not opportunities. On every sheet I try, even with new queries, it will not connect to opportunities. I get the below error. Anyone else having this issue?

Web.Contents failed to get contents from 'mycompanyname.crm.dynamics.com/.../opportunities' (400): Bad Request

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

ToniG 321 on at

Like (0)

Report

RE: Can't Refresh Opportunity connection in Power BI

Sorry, it turned it into a link, here is the full script. Added spaces to keep it from forming as a link.

Web.Contents failed to get contents from 'https:// mycompany.crm.dynamics .com/api/data/v9.0/opportunities?fetchXml=%3Cfetch%20page%3D%221%22%20paging-cookie%3D%22%22%3E%3Centity%20name%3D%22opportunity%22%3E%3Call-attributes%20%2F%3E%3Cfilter%20type%3D%22and%22%3E%3C%2Ffilter%3E%3C%2Fentity%3E%3C%2Ffetch%3E' (400): Bad Request

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans