Power BI

When you apply row-level security to a semantic model, there are limitations in using the USERELATIONSHIP function. This article shows the issues, provides

Explore AI pricing models: Understand fixed vs. variable costs with examples and learn how to choose the right model.

The right title for this blog post should be “Guidelines for SQLBI content publishing”, but it would be too boring. And, at the time of writing, the mor

If you have used Spark in Azure Synapse, prepare to be pleasantly surprised with the compute experience in Microsoft Fabric as Spark compute starts a lot faster because the underlying technology ha…

Introduction OneLake can be used as a single data lake for your entire organization, it provides ease of use and helps eliminate data silos. It can also simplify security while ensuring that sensitive data is kept secure. OneLake and Fabric provide several out of the box capabilities to keep data access restricted to only those … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/building-common-data-architectures-with-onelake-in-microsoft-fabric/" class="more-link">Continue reading<span class="screen-reader-text"> “Building Common Data Architectures with OneLake in Microsoft Fabric”</span></a>

In this article, I explain what it means for your current and future semantic models if you choose for Fabric. This post isn’t meant to market Fabric to you; it’s purely informative.

For years, CDOs have struggled to develop strong data cultures at their organizations. This article explores whether AI can solve data culture challenges for companies.

Our ability to find and tell meaningful data stories will be enhanced, not replaced, by AI. This article explains why augmentation will lead to better data storytelling.

A new feature that enables secure and seamless access to ADLS Gen2 storage accounts from OneLake shortcuts in Fabric  We are excited to announce Trusted workspace access, a new feature in Fabric that allows you to securely access firewall-enabled Storage accounts. With Trusted workspace access, you can create OneLake shortcuts to Storage accounts, and then use … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/introducing-trusted-workspace-access-for-onelake-shortcuts/" class="more-link">Continue reading<span class="screen-reader-text"> “Introducing Trusted Workspace Access for OneLake Shortcuts “</span></a>

Introduction OneLake can be used as a single data lake for your entire organization, it provides ease of use and helps eliminate data silos. It can also simplify security while ensuring that sensitive data is kept secure. OneLake and Fabric provide several out of the box capabilities to keep data access restricted to only those … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/building-common-data-architectures-with-onelake-in-microsoft-fabric/" class="more-link">Continue reading<span class="screen-reader-text"> “Building Common Data Architectures with OneLake in Microsoft Fabric”</span></a>

Writers: John Hoang and Brad SchachtTechnical Reviewers: Steve Howard and Priya Sathy Introduction The following is an article in a series that focuses on the migration from Azure Synapse Analytics to Microsoft Fabric. The first article, ​​Azure Synapse dedicated SQL pools to Fabric migration, discussed options to migrate DDL, T-SQL, and data from Synapse Dedicated … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/mapping-azure-synapse-dedicated-sql-pools-to-fabric-data-warehouse-compute/" class="more-link">Continue reading<span class="screen-reader-text"> “Mapping ​​Azure Synapse dedicated SQL pools to Fabric data warehouse compute”</span></a>

In the era of AI, data has become the cornerstone of analytics platforms. With the ever-increasing volume of data being collected across various applications, data lakes, databases, and data warehouses within an enterprise data estate, the need for secure access to enterprise data sources has become critical. This is particularly important given the growth of … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/introducing-managed-private-endpoints-for-microsoft-fabric-in-public-preview/" class="more-link">Continue reading<span class="screen-reader-text"> “Introducing Managed Private Endpoints for Microsoft Fabric in Public Preview”</span></a>

Uncover a host of updates and enhancements to our new card visual reference labels. This February 2024 update brings many great features including improved alignment of elements, new placement options for reference labels, a new tabular style, a transparency slider for the divider, new per-card customization, and enhanced layout control.

We recently made the following Power BI app improvements you asked for: the ability to copy item links from authoring view, a setting for granting access to hidden content, and increasing the maximum number of audiences to 25 (previously 10).

Copilot for Power BI has new capabilities in Public Preview! Users in view mode can now ask about insights, summaries, trends, and data questions and receive natural language responses, making analysis easier than ever.

I have being playing with Electricity Market Data recently and now I have a #Fabric solution that I think is easy enough to use but more importantly cost effective that it works just fine using F2 …

The latest Power BI update is here, and it’s all about new enhancements that you’re sure to enjoy. Building on December’s transformative update, we’ve fine-tuned columns, bars, and ribbons, giving you even more control over your visualizations. From border enhancements to IBCS-inspired styles, this release is all about making your reports shine.

We are very excited to announce a lot of new improvements to data destinations in dataflows gen 2. Here is an overview of the new improvements and how to get started. After you have cleaned and prepared your data with dataflows gen 2, you want to land your data into a destination. This is possible … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/dataflows-gen-2-data-destinations-and-managed-settings/" class="more-link">Continue reading<span class="screen-reader-text"> “Dataflows gen 2 data destinations and managed settings”</span></a>

As an organisation we have a set of central semantic models that everything runs off. These are checked into GIT and we operate a branching model. Now that TMDL is more fully supported I’ve l…

In this post, we will see how to perform pagination when calling Fabric Rest API from a notebook. Note that at the time of writing this post the Fabric REST API is still in preview. What is pagination Pagination is a process used to divide a large dataset into smaller chunks and each smaller chunk contains a pointer to the next smaller chunk until there’s no more chunk. As Fabric REST API limits the number of records it returns it also...p class="read-more"a class="btn btn-default" href="https://datakuity.com/2024/02/12/pagination-in-fabric-rest-api/" Read Morespan class="screen-reader-text" Read More/span/a/p

In this post, we will explore how to generate large sample data in Fabric. Why do we need to Generate Large Sample Data in Fabric? I can think of many many reasons to generate large sample data in Fabric but one of the reasons I see as crucial is for testing performance or to help us decide which tier we should buy for now or in the future. Today, Fabric offers built-in sample datasets, but they may not suffice for...p class="read-more"a class="btn btn-default" href="https://datakuity.com/2024/02/05/generate-large-sample-data-in-fabric/" Read Morespan class="screen-reader-text" Read More/span/a/p

Learn how to run multiple notebooks in a specific order or in parallel, depending on the dependencies and logic of your data pipeline in Fabric

Real-Time Analytics is a data analytics SaaS experience in the Microsoft Fabric offering Eventstream for capturing, transforming, and routing real-time events, KQL database for data storage and management, and KQL queryset to run queries, view, and customize query results on data. This blog post will explain how to use Power Automate to send events to Fabric Eventstream by using the Custom App as the Source of the Eventstream. Video: Eventstream in Microsoft Fabric: The event streams feature in

In my view, projects and teams of different sizes have different needs. I described DevOps maturity as a pyramid, where most projects don’t require a sophisticated DevOps implementation, and …

Calculated columns in composite models can have a big impact on performance

Use the Parquet.Metadata M function to read metadata from a Parquet file

Learn how to use DAX Query View to get metadata from Power BI Semantic Models including as columns, tables and measures.

This article describes how to optimize time intelligence calculations with DirectQuery over SQL in Power BI by avoiding time intelligence DAX functions. NOT