-
Continue reading →: Organize Your Power BI Model with Measure Tables and Display FoldersIf you’ve been working in Power BI for a while, you’ve probably noticed how messy the Fields pane can get. Between multiple fact tables, dimension tables, and calculated columns, it’s easy to lose track of your measures. That’s where a Measure Table comes in handy. A Measure Table is a…
-
Continue reading →: Microsoft Fabric: Upgrade a Power BI Datamart to a Warehouse Using Manual Steps/DataflowGen2
The deadline to migrate Datamart to Data Warehouse in Fabric is October 1st 2025. In my previous post I explored how to use PowerShell to Migrate a Datamart to a Data Warehouse using an Accelerator. In this post, I will cover the steps to manually Migrate a Datamart to a…
-
Continue reading →: Microsoft Fabric: Upgrade a Power BI Datamart to a Warehouse Using Accelerator PowerShell Scripts
Deadline to Migrate Datamart to Data Warehouse in Fabric is October 1st 2025. There are currently two ways to Migrate a Datamart to a Datawarehouse. Using Accelerator PowerShell Scripts and Manually. Personally, I prefer the manual way – less steps, less time & less chance for error. If you would…
-
Continue reading →: Create APIs for Business Central Power BI ReportingWhile exposing Web Services in Business Central is a simple and effective way for end users to pull data into Power BI, it is not always the most efficient approach. A standard web service will bring in all available fields for a given table, often without the ability to filter…
-
Continue reading →: How to Change Business Central Connection in Power BI (3 Ways)When working with Power BI reports connected to Microsoft Dynamics 365 Business Central, you may find yourself needing to change the data source. Maybe you’re moving from a sandbox to production, switching to a different environment, or simply pointing the report to another company within Business Central. In this post,…
-
Continue reading →: How to Embed Power BI Reports into Business Central Role Centers and PagesIf you’re using Microsoft Dynamics 365 Business Central and Power BI, you’ve likely wondered how to bring your visual reports directly into your day-to-day workflow. Embedding Power BI reports directly into the Role Center or even FactBoxes on specific pages can drastically improve efficiency and decision-making, without switching tabs. To…
-
Continue reading →: Let Users Choose What to See with Field Parameters in a MatrixEver built a Power BI report and thought, “This column is useful for some people… but probably noise for others”? I ran into this exact situation while working on an Item Sales Quantity report. The core view broke sales qty down by month, but I also wanted to give users…
-
Continue reading →: Business Central 25.0/26.0 Power BI App ErrorsWith every software update, users can expect to find bugs within the first wave of a release. Business Central is no exception to that rule. In regard to reporting this can be catastrophic. In this short blog post I will be regularly updating issues related to Business Central Version 25.0…
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.