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.
Tag: Data Lake
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.”
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.
Joel Leichty 