Query 37017 Opportunity - PBI API
src/Apps/W1/PowerBIReports/App/Sales/APIs/OpportunityPBIAPI.Query.al39 lines, Copyright (c) Microsoft Corporation. MIT
// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.Sales.PowerBIReports;using Microsoft.CRM.Opportunity;query 37017 "Opportunity - PBI API"{ Access = Internal; QueryType = API; AboutText = 'Provides access to CRM opportunity master data including status, sales cycle, priority, campaign, and linked sales documents. Enables Power BI reports to analyze opportunity inventory, conversion success, and campaign effectiveness.'; Caption = 'Power BI Opportunity'; APIPublisher = 'microsoft'; APIGroup = 'analytics'; ApiVersion = 'v0.5', 'v1.0'; EntityName = 'opportunity'; EntitySetName = 'opportunities'; DataAccessIntent = ReadOnly; elements { dataitem(opportunity; Opportunity) { column(opportunityNo; "No.") { } column(opportunityDescription; Description) { } column(opportunitySalesCycle; "Sales Cycle Code") { } column(opportunityCreationDate; "Creation Date") { } column(opportunityStatus; Status) { } column(opportunityClosed; Closed) { } column(opportunitySalesDocumentNo; "Sales Document No.") { } column(opportunitySalesDocumentType; "Sales Document Type") { } column(opportunityPriority; Priority) { } column(opportunityCampaignNo; "Campaign No.") { } column(opportunitySegmentNo; "Segment No.") { } } }}