Skip to content

Joel Leichty

Cooptimize • Power BI • Dynamics 365 • Employee Empowerment

  • Blog
  • About and Contact
  • Nomad Life
  • Other Blogs – Dynamics 365 F&O
  • AX 2012 Manuals
    • AX 2012 Core Financials
      • Table of Contents
      • General Ledger
      • Bank Management
      • Accounts Receivable
      • Accounts Payable
      • Blog Posts
    • AX 2012 Trade
      • Table of Contents
      • Products
      • Sales Orders
      • Purchase Orders
      • Inventory Management
      • Blog Posts
    • AX 2012 Projects
      • Table of Contents
      • Blog Posts
  • Twitter
  • LinkedIn
  • YouTube
  • Twitter
  • LinkedIn
  • YouTube
  • Twitter
  • LinkedIn
  • YouTube

Tag: Data Lake

By Joel Posted on July 25, 2022February 3, 2023

Fixing Microsoft’s Power BI Content for Dynamics 365 Sales

As part of Cooptimize’s open source initiatives, we are building better standard Dynamics 365 content, beginning with Sales Analytics.

Categories: Dynamics 365, Power BITags: Data Lake, Microsoft, Open Source, Option Sets, Star Schema
By Joel Posted on June 15, 2022February 4, 2023

Dataverse Power BI Connector Blows Up at 80MB of Data in One Query

When using the Dataverse connector in Power BI Desktop or Dataflows, you may receive this error: “Microsoft SQL: Return records size cannot exceed 83886080. Make sure to filter result set to tailor it to your report.”

Categories: Dynamics 365 F&O, Power BITags: Data Lake, Open Source, Option Sets, Power BI, Synapse Serverless
By Joel Posted on May 16, 2022February 4, 2023

Easily Modify Dataverse Option Set Integers to Text • Power Query Edition

Modifying integers that represent text is a key part of consuming Dataverse data from a Data Lake. Cooptimize provides Open Source code to simplify Integers to Text.

Categories: Business Intelligence, Power Apps, Power BI, Power PlatformTags: Choices, Data Lake, Dataflow, Enums, Integers, Open Source, Option Sets

Categories

  • Books (23)
    • AX 2012 Core Financials (8)
    • AX 2012 Projects (10)
    • AX 2012 Trade (5)
  • Cooptimize (3)
  • Disruptions (1)
  • Dynamics 365 (3)
  • Dynamics 365 F&O (29)
  • Power Platform (27)
    • Business Intelligence (6)
    • Power Apps (4)
    • Power BI (23)
  • Random (29)
    • About Me (4)
    • DynamicsCon (9)
    • Grab Bag (17)

Enter your email address to follow this blog and receive notifications of new posts by email.

Follow Me

  • Twitter
  • LinkedIn

Find more of my blogs at cooptimize.org

Blog at WordPress.com.
Scroll Up
  • Follow Following
    • Joel Leichty
    • Join 248 other followers
    • Already have a WordPress.com account? Log in now.
    • Joel Leichty
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar