Power BI

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 …

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…

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

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”

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…

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

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”

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

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”

Why Bother?

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…

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: &#…

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 …

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…

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.

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...

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…

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: […]

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

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…

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.

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…

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 …

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 …

In this blog post, I am sharing a few things I learned while migrating some Power Query queries to dataflows.

In the previous article, I mentioned what is the Dataflow, how it can be helpful, and mentioned some of the use cases of it in real-world Power BI implementation. In this article as the second part of…

In this video, Patrick looks at the new Power BI Secure Embed. If you have been using Publish to Web internally, you need to look at this feature as it is the perfect replacement that adds a secure option for easy, frictionless, embedding.

In this video, Adam shows an easier approach to get a Power BI Embed Token using PowerShell. This removes the headache of writing code or having to worry about an authentication token. Power BI Embedded Playground Invoke-PowerBIRestMethod Documentation GenerateToken for Reports in a Group PowerShell download