-
Continue reading →: Create Custom CRM OData URLs using XRM ToolboxData – it makes the world – and every organization go round. But what happens when you want to extract mass amounts of data and put it into a tool such as Power BI? In the case of using the Dynamics 365 (Dataverse) connector, you may face long data load…
-
Continue reading →: PBIX. vs PBIP.When working with Power BI, understanding the different file types can significantly impact your workflow and the flexibility of your reporting solutions. Each file type – PBIX, PBIP, and PBIR – has its distinct purpose, advantages, and drawbacks. In this blog we will break down two of these file formats…
-
Continue reading →: Business Central Power BI ReportsWelcome back! In this post we will explore the new(-ish) Power BI Reports for Business Central! The Evolution of Reporting in Business Central Reporting, like everything else, is evolving—at a rapid pace. With the explosion of AI tools, this evolution is only accelerating. We’ve already seen this with AI-driven model…
-
Continue reading →: SQL Server SSL Power BI/Fabric Error (DECEMBER 2024)Power BI Errors – they happen. This unique error came directly from a client who is utilizing Datamarts in Power BI Service. Said Datamart had many connections to Dataflows and many queries were constructed using SQL. In December 2024 after many months of utllizing the Datamart and connected report with…
-
Continue reading →: Visual Calculations – Use Case, Considerations, and LimitationsVisual Calculations in Power BI are a feature (released as Public Preview Feb 2024) that allows users to apply calculations directly to visuals without creating separate measures. This includes common functions like running totals, moving averages, and percentage of total, making it easier to add dynamic insights to reports quickly.…
-
Continue reading →: Create Web Services in Business Central for Power BI ReportingIn the world of BC Reporting, it all starts with your data. When utilizing Power BI for Business Central Reports getting started can seem overwhelming. In this post I wanted to quickly cover the process of how you can expand your sandbox of data and expose more Web Services than…
-
Continue reading →: #PPCC24 Opening Keynote Recap — Building the Future Together: Power Platform, Copilot, and the Power of CommunityMPPC PPCC (did you catch the name change?) is officially in full swing! The 3rd annual Microsoft Power Platform Conference kicked off in style here in the beautiful Las Vegas, NV. Charles Lamanna opened the event with a keynote that electrified the room, emphasizing the community-centric and AI-driven future of…
-
Continue reading →: Business Central OData “Can Not Convert Type Null” Power BI Error (SEPTEMBER 2024)As someone who began their career learning about the Power Platform and using it to extend Microsoft Business Central, I am no stranger to OData woes. Whether it is connection errors or poor load performance due to large amounts of data. In this blog post I wanted to touch on…
Hello,
I’m Sav
Welcome to Not a Pickle Blog, a technical resource focused on Power BI and Microsoft Dynamics 365 Business Central. I’m Savannah, and this blog is dedicated to translating complex data models, APIs, and business processes into practical, actionable insights. You’ll find deep dives into reporting patterns, real-world Business Central scenarios, Power BI best practices, and lessons learned from hands-on experience. The goal is simple: build reliable reports, understand your data, and make it work for your business.
Let’s connect
Join the fun!
Stay updated with our latest tutorials and ideas by joining our newsletter.
