We are excited to announce the April 2024 release of the on-premises data gateway!

We have some exciting announcements to share regarding Copilot in Microsoft Fabric. The information in this blog post has also been shared with Fabric tenant administrators. Below are the highlights of the changes.

There are a couple of nice new features to do with table joins (or merges as they are known in M) and query folding in Power Query in the April release of Power BI Desktop that I want to highlight. Anti Joins now fold First of all, a few months ago I wrote a post … Continue reading New Semi Join, Anti Join And Query Folding Functionality In […]

This is the blog on how to deliver Power BI and paginated report subscriptions to OneDrive and SharePoint.

Last week we published a new version of our Mailchimp Power BI App: Analytics for Mailchimp (previously known as “Mailchimp Email Marketing”). The app is available on Microsoft AppSource. Analytics for Mailchimp is a Power BI app that connects to your Mailchimp account and analyzes the performance of your campaigns. An active Mailchimp account […]

Power BI April 2024 Feature Summary Welcome to the April 2024 update. There is more to explore, please continue to read on.

Earlier this year, we announced Copilot preview for all customers with Premium/Fabric capacity in Power BI web. We’re thrilled to share that the same Copilot experience for report creation is now available for preview in Power BI Desktop.

PowerPoint lets you play a presentation continuously. This is handy when you want to show information on public screens without anyone having to control it. In this update, we added a new configuration to Storytelling add-in that ensures that you get the latest data from Power BI when running in a continuous slide show. When enabled, the add-in […]

The built-in mapping functionality in Power BI paginated reports is fairly basic. However the integration of Power Query into Power BI paginated reports gives you an interesting new way of creating maps in paginated reports: you can call the Azure Maps API using Power Query and display the image returned in an Image report item. … Continue […]

Can you believe how amazing and hectic March has been?! So many community members got to experience some major conferences all next to each other. We had the MVP Summit,…

Boost your productivity in DAX query view with Copilot to write and explain DAX queries.

By far the most exciting announcement for me this week was the new release of Power BI Report Builder that has Power Query built in, allowing you to connect to far more data sources in paginated reports than you ever could before. There’s a very detailed blog post and video showing you how this new … Continue reading Power BI Paginated Reports […]

Connect to100+ data sources and create paginated reports.

We are excited to announce that Mirroring, previously announced at Ignite in November 2023, is now available to customers in Public Preview. You can now seamlessly bring your databases into OneLake in Microsoft Fabric, enabling seamless zero-ETL, near real-time insights on your data – and unlocking warehousing, BI, AI, and more. 

Power BI March 2024 Feature Summary Welcome to the March 2024 update! Here are a few, select highlights of the many updates we have for Power BI. There are new updates for Visual calculations, edit your data model in the Power BI Service, and deliver report subscriptions to OneDrive SharePoint. There is more to explore, please continue to […]

I recently took part in a webinar with Denny Lee, Liping Huang and Marius Panga from Databricks on the subject of best practices for using Power BI on Databricks. You can view the recording on LinkedIn here: https://www.linkedin.com/video/live/urn:li:ugcPost:7174102151407779841 …or on YouTube here: My section at the beginning covering Power BI […]

There’s a lot of excitement about Copilot in Power BI and in Fabric as a whole. The number one question I’m asked about Copilot by customers is “How much does it cost?” and indeed there have been two posts on the Fabric blog here and here attempting to answer this question. The point I want … Continue reading How Much Does Copilot Cost […]

Many Power BI connectors for relational databases, such as the SQL Server connector, have an advanced option to control whether relationship columns are returned or not. By default this option is on. Returning these relationship columns adds a small overhead to the time taken to open a connection to a data source and so, for … Continue reading […]

If you’re tuning a DirectQuery semantic model in Power BI one of the most important things you need to measure is the total amount of time spent querying your data source(s). Now that the queries Power BI generates to get data from your source can be run in parallel it means you can’t just sum … Continue reading Measuring The Total Time […]

Hybrid tables – tables which contain both Import mode and DirectQuery mode partitions to hold data from different time periods – have been around for a while. They are useful in cases where your historic data doesn’t change but your most recent data changes very frequently and you need to reflect those changes in your … Continue reading […]

In this episode of Kasper On BI we are talking about AI, LLM’s and CoPilots. This is such a hot topic in the industry that I wanted to take the... The post Everything AI, LLM’s and Microsoft Fabric CoPilot with Alex van Grootel appeared first on Kasper On BI.

The more you monitor something the more likely it is that you’ll see something strange you can’t explain. This is true of several customers I’ve spoken to recently who saw DAX queries run in the middle of the night by people who were definitely not online at the time and who were worried about the … Continue reading Query Caching In Power […]

There’s a new M function in Power Query in Power BI that allows you to read the data from a Parquet file: Parquet.Metadata. It’s not documented yet and it’s currently marked as “intended for internal use only” but I’ve been told I can blog about it. Here’s an example of how to use it: …and … Continue reading Reading Parquet […]

We released a tool to help you bulk-download all of the Power BI custom visuals from Microsoft AppSource, to help you gain control of the repository of custom visuals for your organization. The tool is available to download here. The free version of the tool will allow you to download the 20 recent visuals and The post Power BI Custom Visuals […]

We have just published a new resource on GutHub for the Power BI community to allow Power BI developers and administrators to access Power BI custom visuals outside Microsoft AppSource for automation and other purposes. In this blog post, we will delve into the PowerBI-Visuals-AppSource repository. We hope it can be an invaluable resource for The […]