Power BI

With the newest version of OneLake file explorer (v1.0.11.0) we bring a few updates to enhance your experience with OneLake. Excel Integration: Editing made Easy  With our latest release v1.0.11.0 of file explorer, we are excited to announce that you can now update your files directly using Excel, mirroring the user-friendly experience available in OneDrive. … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/onelake-file-explorer-update-via-excel-made-easy/" class="more-link">Continue reading<span class="screen-reader-text"> “OneLake File Explorer: Update via Excel made Easy”</span></a>

To get Copilot turned on for everyone in your organization, follow these steps: Sign in to Microsoft Fabric using your admin account credentials. Select Fabric settings and then from the menu select Admin portal. Select Tenant settings and scroll down the page to “Copilot and azure Open AI Service(preview)” and turn on Enabled On your … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/how-to-enable-copilot-in-fabric-for-everyone-2/" class="more-link">Continue reading<span class="screen-reader-text"> “How to enable Copilot in Fabric for Everyone”</span></a>

Microsoft Fabric provides a cloud-scale data warehouse to store your analytical data for dashboards and historical reporting. In Fabric Data Factory, there are a number of ways to query data, retrieve data, and execute commands from your warehouse using pipeline activities that can then be easily automated for unattended background execution. I’ll go left-to-right from … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/automate-fabric-data-warehouse-queries-and-commands-with-data-factory/" class="more-link">Continue reading<span class="screen-reader-text"> “Automate Fabric Data Warehouse Queries and Commands with Data Factory”</span></a>

With the model explorer available for editing data models in the Power BI service these semantic models, both Direct Lake and those in import or DirectQuery, not only get visibility of their semantic model in a tree view but also can create calculation groups!

Last year was a remarkable one for the Power BI community. We launched Microsoft Fabric, an end-to-end analytics platform that brings together data preparation, data warehousing, data engineering, data science, real-time analytics, and business intelligence in one unified SaaS foundation with one copy of data stored in OneLake. We also launched Power BI Copilot, making it easier to find insights and build reports using natural language. And our community of over 2 million members continued to engage on our forums, post ideas, join user groups, helping one another in their data journeys.

We are excited to announce that the Copilot preview is now available to all customers!, Now everyone can get value from copilot through analyzing data or creating beautiful out of the box reports.

We’re excited to announce that dynamic per recipient subscriptions are now available in Preview for Power BI reports! Similar to dynamic subscriptions for paginated reports, you can now distribute a personalized copy of a Power BI report to each recipient of an email subscription.

In this blog post I show you how to grant users access to create Fabric items in a Fabric enabled workspace in Power BI.

Troubleshooting DAX performance is one of the most challenging, yet most rewarding tasks! Learn how to leverage DAX Studio external tool to quickly understand why your DAX query is slow!

Last year was a remarkable one for the Power BI community. We launched Microsoft Fabric, an end-to-end analytics platform that brings together data preparation, data warehousing, data engineering, data science, real-time analytics, and business intelligence in one unified SaaS foundation with one copy of data stored in OneLake. We also launched Power BI Copilot, making it easier to find insights and build reports using natural language. And our community of over 2 million members continued to engage on our forums, post ideas, join user groups, helping one another in their data journeys.

During November 2023, we unveiled the public preview of Copilot in Microsoft Fabric. This preview includes Copilot for Power BI, Data Factory and Data Science & Data Engineering. Since then, we have been gradually rolling this feature out and today, we are excited to announce that our Copilot preview is now available to all customers! With the Copilot preview, Microsoft … Continue reading “Copilot in Fabric (preview) is available worldwide “

<p>Streamline your organization’s approval processes with the Approvals Kit – a no-code, ready-made kit built on top of Power Platform components. With over 20 cloud flows and a Power Apps app, the Approvals Kit offers sophisticated approvals such as conditional branching, delegation, admin overrides, and more. And the best part? You can configure all of this without writing a single line of code. Try the Approvals Kit now and see how it can empower every person in your organization to ‘do more with less’ for your approval needs.</p>

If you are starting to enjoy using Microsoft Fabric more, especially the exciting new Direct Lake storage mode, you may find this simple tip useful to help monitor your semantic models. The idea behind this tip is to run a DMV (can be any DMV) on a regular basis against a semantic-model and accumulate results … Continue reading Use Fabric Notebook to monitor Power BI semantic models

Recently, I had two enterprise customers with whom I was in conversation about Microsoft Fabric and how it could complement their existing data landscape. Both of these customers have a data platfo…

Microsoft Fabric’s Lakehouse helps us better unified management of enterprise-level data environments. In the process of transforming to AI, we cannot do without the assistance of these enterprise data. In my previous blog, I mentioned how to build RAG applications based on data in the Microsoft Fabric environment. In this post, I will introduce how … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/using-microsoft-fabrics-lakehouse-data-and-prompt-flow-in-azure-machine-learning-service-to-create-rag-applications/" class="more-link">Continue reading<span class="screen-reader-text"> “Using Microsoft Fabric’s Lakehouse Data and prompt flow in Azure Machine Learning Service to create RAG applications”</span></a>

No one person can perform every data-related task in an organization. Here's a way to explain role classification by skill set.

In a previous post, I shared a comprehensive guide on implementing Incremental Data Refresh in Power BI Desktop. We covered essential concepts such as truncation and load versus incremental load, understanding historical and incremental ranges, and the significant benefits of adopting incremental refresh for large tables. If you missed that post, I highly recommend giving … Continue reading Incremental Refresh in Power BI, Part 2; Best Practice; Do NOT Publish Data Model Changes from Power BI Desktop

If you keep up with the latest developments in the data space, you will probably know that Microsoft Fabric has now reached general availability. One of the trickiest things we’ve had to come to terms with is how concurrency works and how to run multiple notebooks at once without errors.

In this article, I discuss why quality is a problem for data and analytics, and how DataOps can help.

With the general availability of Microsoft Fabric this past Ignite, there are a lot of questions centered around the functionality of each component but more importantly, what architecture designs and solutions are best for analytics in Fabric. Specifically, how your data estate for analytics data warehousing/reporting will change or differ from existing designs and how to choose the right path moving forward. This article will be focused on helping you understand the differences between the Data Warehouse and Data Lakehouse, Fabric solution designs, warehouse/lakehouse use cases, and to get the best of both Data Warehouse and Data Lakehouse.

During the recent Ignite 2023 event, we announced the public preview of prebuilt AI services in Fabric. This integration with Azure AI services, formerly known as Azure Cognitive Services, allows for easy enhancement of data with prebuilt AI models without any prerequisites.  Using AI services in Fabric has never been easier! In the past, you … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/prebuilt-azure-ai-services-in-fabric-2/" class="more-link">Continue reading<span class="screen-reader-text"> “Prebuilt Azure AI services in Fabric”</span></a>

Welcome to the December 2023 update. We have lots of features this month including More styling options for column and bar charts, calculating distinct counts in Power BI running reports on KQL Databases, Changes to workspace retention settings in Fabric and Power BI, and many more.

Microsoft Fabric’s Lakehouse helps us better unified management of enterprise-level data environments. In the process of transforming to AI, we cannot do without the assistance of these enterprise data. In my previous blog, I mentioned how to build RAG applications based on data in the Microsoft Fabric environment. In this post, I will introduce how … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/using-microsoft-fabrics-lakehouse-data-and-prompt-flow-in-azure-machine-learning-service-to-create-rag-applications/" class="more-link">Continue reading<span class="screen-reader-text"> “Using Microsoft Fabric’s Lakehouse Data and prompt flow in Azure Machine Learning Service to create RAG applications”</span></a>

One of my older posts explains how to enable Copilot on Fabric and how to use Copilot to generate Power BI reports. In this post, I aim to explain yet another use case for Copilot that can help us to make a better and more useful semantic model in Power BI using synonyms. In an … Continue reading Microsoft Fabric: Use Copilot to Generate Data Model Synonyms

Game changer! How many times did you hear these words? But, with the latest OneLake integration for semantic models feature in Fabric, we may really change the way of engineering data workloads

".pbit" files are well-known in the Power BI world. But this is not the only type of "template" we can encounter. It depends on the scenario we are trying to fulfill.