Power BI

This post describes how to manage Approvals in a Power Apps canvas app by leveraging a Custom connector that extends the capabilities of the Approvals connector.

Today I discovered a way to easily copy all queries (including the groups) from a PBIX file to Excel without entering the power query editor in Excel. In my case I needed to copy the data returned …

A common topic I have been discussing recently with customers is the security around Power BI. Basically, how to prevent users seeing data they shouldn’t. So I’ll discuss the various &#…

I recently on some internal email by the developers where they mentioned something, offhand, what I think is amazing :). It will allow you to add measures by copy and...

How Rockwell Automation drives a data culture using Power BI and Azure

Announcing – Copy a Visual as an Image in Power BI Service

April release of gateways.

Today, I’m excited to introduce the new look of workspaces in the Power BI service. Check it out!

Imagine that you are building a Power BI dataset for corporate reporting, that will also be reused for self-service purposes by many others. It is up to you, as dataset author, to make it as simple…

We’ve updated the prediction model performance page in AI Builder. Now, there’s a performance grade to help give you a better idea of how the model is performing. We’ve also added a new performance tab on the training details pane to provide more detailed information to help you evaluate performance.  These improvements help you decide when a model is ready to publish.

One of the most common errors you’ll see when working with Power Query in Power BI or Excel is this: Expression.Error: The key didn’t match any rows in the table It can occur with almos…

Want to download files from webpages with Power Query to regularly refresh in Power BI? See how to find their URL and tweak their parameters to your needs:

PowerShell 7.0 was made generally available last month and one of it’s new features is pipeline parallelization for the ForEach-Object cmdlet. Scripts running on PowerShell 7 or higher can si…

Substring is one of the most common functions in many languages, However, there is no function named Substring DAX. There is a very simple way of doing it, which I am going to explain in this post. Substring means getting part of a string, for example from "Reza Rad", if I want to get the…

In this post series, I am going to show how to use new Q&A visuals for the aim of creating easy visuals by typing the natural language and define some user-defined terms and how to manage it. This visual is now generally available for everyone. IN this post some introduction to this visual about how…

Power BI is taking off, and it’s fast becoming the most popular business intelligence platform on the market. It’s easy to engage with and get professional results quickly, making it the perfect tool for organisations looking to beef up their BI prowess and make data driven decisions through-out the organisation. In this post we’re going … Continue reading Power BI Governance, Good Practices, Part 1: Multiple Environments, Data Source Certification and Documentation

It’s time to recap all the features and announcements we made for the Power BI service and mobile for the months of February and March.

On Monday, as news of COVID-19 cases spread globally, we pulled together a team to help customers coordinate their own information sharing and team collaboration in response to evolving conditions in times of crisis. Today, less than 48 hours later, we’re releasing the first version of that solution for any customer organization to quickly implement.

In my last tutorial here, you learned how to import COVID-19 confirmed and death cases from Johns Hopkins dataset to build your own Power BI dashboard using Power Query. In this tutorial, we will go quickly through the DAX measures that will help you gain better analytics capabilities using Power BI time intelligence. To follow …

In the Power BI community, had the idea of providing Power BI COVID-19 dashboards as screensaver. After a brief research, the following blog post was created. In order to be able to display web pages as screensavers on Windows 7 or newer, I use the Web-Page-Screensaver from Cameron Currie. The corr...

This post walks through a simple use of the coalesce function to prevent a measure returning Blank. This function was introduced to Power BI in March 2020.

<p>With Teams context variables, you now have access to information like which channel, team, or group your app has been embedded in. With that information, you can now build apps that automatically filter down to relevant content, pre-populate fields, or respond to the users Microsoft Teams theme. Additionally, you can use this information to support deep linking to pages within your app.</p>

If you're looking for a new intranet to help your remote working colleagues, then look no further. We have everything you need to get started today!

We are excited to announce the April 2020 Wave 1 update for AI Builder is now available. This update includes six AI Builder preview model types that are becoming generally available, key feature updates to existing models like forms understanding and text recognition, and new models for entity extraction and numeric prediction. There are also a dozen new AI Builder templates to help you get started with AI Builder in Power Automate.

We know that some key decisions need to be made before launching an intranet quickly. Which is why we sat down with Sebastien Levert, Microsoft MVP.

I have a Power Query script that I usually use in any Power BI solution that needs time-based analysis. However, I never had a chance to publish it here for everyone to use. So here it is. A friend's question about a time table reminded me that it is good to publish this to the…

Today we’re announcing the robotic process automation (RPA) capability in Microsoft Power Automate, called UI flows, will now be generally available.