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: Synapse Serverless

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

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