web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Power Bi and Dynamics CRM: How to get info from one particular opportunity

(0) ShareShare
ReportReport
Posted on by

Hello people,

Kind of new here and I'd like to ask whether something is possible or not.

(I did a search, but not a tthorough one)

I'd like to create a quote-maker, within Dynamics or preferably in Excel using Power BI.

If the quote-maker would be in Dynamics, I should be able to export the quote into a pre-formatted Excel file.

If it's from within Excel, I'd like to input the Opp number and information should automatically be pulled from the Dynamics DB.

I already got the connection between the CRM and Excel with Power BI using the OData Feed connector, but from then on I'm stuck.

Am I asking too much from, is it even possible?

Please let me know, cheers!

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Aileen Gusni Profile Picture
    44,524 on at

    Hi Fidiba,

    I think this article would help you:

    andz88.wordpress.com/.../enable-dynamics-crm-odata-query-filter-for-powerquery-performance

    And I recommend you to download odata query designer and install this solution into your CRM Organization.

    crm2011odatatool.codeplex.com

    Or the desktop app

    dynamicsxrmtools.codeplex.com

    It will help you to build the query not only based on the Opp Number but also any other queries.

    Or there is another way around, you download all the Opportunity List and then filter using the Excel Data Filter

    Hope this helps!

    Thank you.

  • Community Member Profile Picture
    on at

    Thank you Aileen,

    I already read the first link but I'm very interested in the Odata Query Designer, going to have a look at it this weekend.

    Cheers!

    fabio

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
JS-09031509-0 Profile Picture

JS-09031509-0 3

#2
AS-17030037-0 Profile Picture

AS-17030037-0 2

#2
Mark Eckert Profile Picture

Mark Eckert 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans