There have been lots of announcements about Dataflow online, through videos and articles and news. There are many demos about Dataflow as well. However, still when I talk about it in conferences, one …

Happy new year everyone! We are kicking off the new year with an update to Power BI dataflows, focused on the dataflows editor. Power BI dataflows was introduced to public preview in November, and …

Earlier last year, we announced bookmarking to be generally available in Power BI Desktop. Bookmarks are currently used by many report authors to share interesting insights, tell a story, and creat…

Patrick looks at how you can add a link to your Power BI Paginated report and open a Power BI report while passing filters over to explore data.

In this week’s webinar Ted Pattison will be covering how to develop Custom Visuals for Power BI. Power BI has supported the development of custom visuals since its initial release. However, t…

This blog post covers the latest updates for Power BI embedded analytics and Custom Visuals.

Whitelisting Azure IP addresses for Key Vault (@UOldfield) The Necessary Extras That Aren’t Shown in Your Azure BI Architecture Diagram (@mmarie) Finding the Flow: A Beginner’s Guide to Microsoft Flow (@PowerPivotPro) Use more variables in DAX to simplify your life (@kjonge) Easily embed secure Power BI reports in your internal portals or websites BONUS ITEMS: […]

Microsoft rolled out a new embedding feature for Power BI content. Next to the already known features as Embed in SharePoint Online, Publish to Web and Power BI Embedded, there is a new feature ava…

When attempting to connect Power BI to a JSON file on SharePoint, and used the Copy link URL of the JSON file. Received the following: The JSON file points to an URL API. There are no issues when connecting to the JSON file when it is located on the desktop, nor when connecting to the URL API...

Patrick finishes his look at Paginated Reports in Power BI. He shows you how to create sparklines, indicators and conditional formatting within the Paginated Report using Report Builder.

Power BI already has an easy way to embed Power BI reports into public websites with Publish to web and to secure SharePoint Online pages with the Power BI web part. However, embedding content into…

I don't hear this question as often as I used to[1], but I still hear it: What's the difference between dataflows in Power BI and Data Flows in Azure Data Factory? I've already written extensively on …

We are excited to announce that we have just released the December update for the On-premises data gateway. Here are some of the things that we would like to highlight with this month’s release: &#…

Warning This is a less ranty than my first “road to MVP” post.I’m finishing this post at the end of december. And while I know there’s already a 3rd part as well, I found it…

Why Bother?

We saved the best for last. The final stretch of 2018 was incredible for the Power BI team. We announced some of our biggest previews, rolled out new features, and improved existing functionality across service and mobile based on your feedback. Before we ring in the new year, here’s a quick recap, in case you … Continue reading “Power BI Service and Mobile November & December Feature Summary”

Case Power BI recently introduced Dataflows. What is it and who should use it? Power BI Dataflows Solution According to M...

We are excited to announce that we have just released the December update for the On-premises data gateway. Here are some of the things that we would like to highlight with this month’s release: – Enhancements in SAP BW connector – The On-premises data gateway now includes the December version of the mashup engine The … Continue reading “On-premises data gateway December update is now available”

Power BI service apps, workspaces, dashboards, reports, datasets, and workbooks.

If you're a Power BI administrator you're probably already familiar with the Power BI Management module of PowerShell cmdlets. Additionally, as an alternative to PowerShell, you may have seen the rece…

This has been a great year for Power BI service admins. In July, we shipped APIs and PowerShell cmdlets for Power BI management, and recently we also released a preview version of a Workspaces page in the Power BI Admin Portal (see the screenshot below). This page lists all the workspaces in a tenant and … Continue reading “Workspace Management in the Admin Portal”

The Power BI Premium Capacity Metrics (version 1.10) app makes navigating and viewing metrics at workspace level easier.

Azure Data Factory v2 (ADF) has a new feature in public preview called Data Flow. I have usually described ADF as an orchestration tool instead of an Extract-Transform-Load (ETL) tool since it has…

I’m a heavy user and fan of Power BI. It’s a great tool for building reports from multiple data sources and easily sharing them with others. I use it for a variety of internal needs …

A few recent posts have touched on different aspects of how dataflows have capabilities that aren't exposed in the current preview user experience in Power Query Online. This is true of Power Query "M…

How to Create an AAD Account for Power BI Step One: Navigate to portal.azure.com to create a new tenant account using your company account (or create a new one). Step Two: Click on "Azure Active Directory" in the left menu. Step Three: Choose "Create a Directory" on the bottom right...

You can use custom Power Query “M” functions in Power BI dataflows, even though they’re not exposed and supported in the preview Power Query Online editor to the same extent they …

One key aspect of Power BI dataflows is that they store their data in CDM folders in Azure Data Lake Storage gen2.[1] When a dataflow is refreshed, the queries that define the dataflow entities are ex…