Reporting on Data with a Start and End Date in Power BI • Date Concepts for CRM and HR
DAX formula and Data modeling techniques for reporting across date ranges.
Category: Power BI
Use Power Automate HTTP Connector to Publish .pbix File Using the Power BI API
This will describe how to Publish a file from SharePoint to PowerBI.com using Power Automate HTTP Connector to call the API. You might end up on this blog after looking … Continue reading Use Power Automate HTTP Connector to Publish .pbix File Using the Power BI API
Dynamics 365 My Sales Power BI Content OR The Reason Salespeople Don’t Update Data In CRM Is They Get Minimum Value Back
We now have our first open source Power BI Report available on Github. The Report is a “My Sales” experience for Dynamics 365 Sales.
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.
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.
I Did a Thing
I co-founded a new company, Cooptimize (https://cooptimize.org/)! Starting a new company is something I’ve thought about for a long time. But I never could quite figure out all the pieces … Continue reading I Did a Thing
Joel and Zoë on Channel 9
I did an interview on the #LessCodeMorePower channel. Check it out! The learning journey of the PowerPlatform with Zoe Leichty-Wireman and Joel Leichty | #LessCodeMorePower | Channel 9 (msdn.com)
Nobody Puts DynamicsCon In A Corner
DynamicsCon in March 2021 and Joel’s proposed session.
Power BI “Embedded” in Dynamics 365, SharePoint, and Teams
A common Power BI related request is embedding reports within other Microsoft applications. “Embedding Reports” is a simple concept; however, there are important nuances and design options for deployment. Microsoft … Continue reading Power BI “Embedded” in Dynamics 365, SharePoint, and Teams
Should I Learn Power BI? (Video)
I recently started a new video project exploring what it’s like for someone to learn Power BI from zero knowledge. The first episode explores why someone might want to go … Continue reading Should I Learn Power BI? (Video)
8 ½ Power BI Concepts I Wish I Knew When I Started • YouTube
Time Stamp Chapter Title Blog Post 00:04 What Are You Good At? (Intro) 02:15 Title, Welcome, and My Superpower 04:22 Moving From Excel to Power BI 09:14 Data Modeling Table … Continue reading 8 ½ Power BI Concepts I Wish I Knew When I Started • YouTube
Joel Leichty 