Power BI

A few blogs back I shared a technique using Power BI Profiler (or VS Code) to run and capture a trace over a refresh of a Power BI semantic model (the object formally known as a dataset). I’ve since received a lot of positive feedback from people saying how useful it was to visualize each … Continue reading Visualize Power BI Refresh using Semantic-link

In Nov 2023, Microsoft announced Microsoft Fabric’s general availability and Public Preview of Copilot in Microsoft Fabric. In a previous post, I explained what Copilot means to Power BI developers, which is valid for other Fabric developers such as data engineers and data scientists as Copilot for Fabric helps with those experiences as well. But … Continue reading Microsoft Fabric: Generating Reports with Copilot

In November 2023 release we added a new fourth view in public preview to Power BI Desktop, the DAX query view! The DAX query view gives you the ability to write, edit, and see the results of Data Analysis Expressions or DAX queries on your semantic model. Finally, you can now take advantage of the existing DAX queries syntax while working with your semantic model without leaving Power BI Desktop.

SAP systems hold some of the most valuable data of many enterprises, large or small. Whether it is operational data in ERP systems like SAP ECC or SAP S/4HANA, data from SAP’s data warehouse suite of products like SAP BW or SAP Datasphere, or data from SAP’s SaaS solutions – a comprehensive view on the … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/integrate-your-sap-data-into-microsoft-fabric/" class="more-link">Continue reading<span class="screen-reader-text"> “Integrate your SAP data into Microsoft Fabric”</span></a>

Optimize Direct Lake fallback behavior in Power BI with XMLA. Direct Lake size limits, Tabular Editor, rowgroup

This blog post shows how to transform data in a Microsoft Fabric notebook using the data wrangler with a Py spark data frame.

Semantic Link adds support for the recently released OneLake integrated semantic models! You can now directly access data using your semantic model’s name via OneLake using the read_table function and the new mode parameter set to onelake. This approach ensures that no load is placed on Analysis Services, enabling efficient data retrieval and avoids putting … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/semantic-link-onelake-integrated-semantic-models/" class="more-link">Continue reading<span class="screen-reader-text"> “Semantic Link: OneLake integrated Semantic Models”</span></a>

Summary statistics are essential, but we have to learn how to avoid major pitfalls

As a reaction to an article from SQLBI this blog post shows an alternative way of detecting selection in Field Parameters and Calc Groups

Did you know you can use Tabular Editor with Fabric to build advanced Power BI semantic models? Find out some of the advantages that this approach can give you.

Learn how Microsoft Purview and Microsoft Fabric work together to empower data discovery and governance. Find out how access Fabric items.

Optimize Fabric notebook JSON visualization with panel, Bokeh, and pandas' json_normalize for interactive, efficient analysis

Like many I am also playing with Fabric, many of my clients are also excited about Fabric and want to know more about it. Being a solution architect in the…

Last week I found a nice little hack that enables us to create a dynamic slicer with one or more levels and let the user pick the different levels in the slicer. This has been very useful in one of…

Power BI table visuals with a visual-level filter applied may perform worse than expected, and applying the filter inside your measures may improve performance

Using variables with IF or SWITCH can affect performance

You know the story, sometimes other things are more important and you forget to clean up. What happen is, after a while you get an email from Microsoft. Right, this email reminds you about the automated cleanup of my inactive Power Platform environments. This is good, because it helps to reduce unneeded resources. I got this email from one of my Demo Environments: In detail, I use this Dataverse Environment to simulate Application Lifecycle Management for Power Platform. In this... Read More Read More

Copilot in Azure Data Studio is a game-changer for developers worldwide. Its ability to provide intelligent code suggestions and completions significantly..

Have you heard about the new kid in town – Microsoft Fabric? In public preview since May 2023 (Microsoft Build) we had some time to play with it and build our first projects based on this new…

The name "semantic model" highlights the fact Power BI is a semantic layer

Unlock the Full Potential of Power BI DirectQuery: Expert Tips to Optimize Performance and Efficiency in Your Reports

The landscape of business operations is undergoing a seismic shift, driven by the advent of advanced data platforms. Microsoft Fabric is at the forefront of this transformation, heralding a new […]

As part of Microsoft Fabric, we have new Gen2 Dataflows and they have a new ability. A Gen2 Dataflow entity can have a destination, eg a table

Datasets are being renamed to semantic models in Power BI and Fabric. This will make the product clearer and more usable and reflects the immense progress that Power BI datasets have made in becoming an enterprise-grade semantic modeling technology. The semantic model name will help drive awareness of the unparalleled capabilities provided.

As we embark on our quest to unravel the mysteries of the data within Fabric, a world of possibilities awaits. Let’s continue our journey in understanding and exploring the data. In this installment, our attention is directed to how to explore the functional dependencies -relationships between columns in a table. With a specific focus on … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/fabric-changing-the-game-validate-dependencies-with-semantic-link/" class="more-link">Continue reading<span class="screen-reader-text"> “Fabric Changing the game: Validate dependencies with Semantic Link – Data Quality”</span></a>

Explore the essentials of Power BI Waterfall Charts in our comprehensive guide. Learn to create, customize, and integrate these charts effectively

Does the term 𝐕𝐢𝐬𝐎𝐩𝐬 sound familiar❓❓ like DevOps, MLOps and DataOps... ✅This is the term used to ensure that the BI visuals and graphic elements on report pages are consistent, performance-optimized, and accessible before publication. ✨Implementing the CI/CD process for with Power BI project files (PBIP), through the 𝐅𝐚𝐛𝐫𝐢𝐜, 𝐆𝐢𝐭 𝐚𝐧𝐝 𝐀𝐳𝐮𝐫𝐞 𝐃𝐞𝐯𝐎𝐩𝐬 𝐢𝐧𝐭𝐞𝐠𝐫𝐚𝐭𝐢𝐨𝐧, involves performing a series of development quality controls before each deployment.