Power BI

Does your company plan to disable Power BI Custom Visuals, or allow only visuals from the organizational store? Do you need to detect all legacy or v1.1 obsolete custom visuals in your reports? You can run this Power BI Custom Visuals Scanner report on an input folder in which you placed all Power BI report files …

In this post, I want to dive into some of my best practices for Power BI Desktop development. I think bringing all these ideas together will give you a very good understanding of how I like to approach all Power BI reporting and analysis that I complete myself. I follow each of these best practi...

Reference vs Duplicate in Power BI; Power Query Back to Basics (@Rad_Reza) Power BI Cheat Sheet (@DaveRuijter) #PowerQuery everywhere 🙂 – now in #microsoftflow as well (@donsvenson) Premium Capacity …

Case I want to download all my SSRS reports (and data sources) from my Reporting server, but not manually. Is there a solution? My Repor...

Power BI gives you the ability to use a wide variety of data sources in your data visualization project. This walkthrough shows you how to access files in a Azure Data Lake and import them into a Power BI data models.

This week we’ve got another episode of SQLChefs with Bert Wagner, where we talk about the different between datasets, reports and dashboards in Power BI. What are datasets? A Power BI Dataset is a ser…

Last week was Microsoft Ignite time in Orlando, FL. A week full of technical content and announcements. And the Power BI team was also there and presented several sessions around the Power BI cosmo…

Brand new layout for Power BI Desktop. This layout idea provided by the Microsoft team as a part of their September Power BI Blog Release, Download it here!

Fun with DAX – Minesweeper (@PhilSeamark) Power BI Visuals Reference (@marcorus) Comparing Rows in Power Query Part 1 (@PowerPivotPro) Developing with Power BI Embedding (Part 1) (@criticalpath) See Power BI Preview Features in action at the Power BI World Tour BONUS ITEMS: Can You Use Power Query In Power BI Or Excel To Write Data […]

Hello P3 Blog readers! Well, it’s been a while since I’ve blogged – what can I say, it was a busy summer! BOO you say?! You need your Cat Meme fix!?! Well, let’s see if I can DO something about that! …

What tool do you use for Analysis Services Tabular development? SSDT right, what else? Here is a little secret. I almost don’t use SSDT anymore, except for limited tasks, such as importing new tables …

Visually Appealing Power BI Reports (@ExceleratorBI) So, You’re Getting a Data Warehouse for Power BI… (@PowerPivotPro) Power BI Developer community September update Deep dive in the organizational cu…

This month’s update for Power BI Desktop filled with both small and large improvements across the entire product. One huge update is support in the Power BI service for both our composite model and ag…

Working with big data, even massive data can be a real challenge in Business Intelligence platforms. #PowerBI is no exception. The new aggregations feature in Power BI looks to solve that problem. We sit down with Christian Wade, the Power BI PM that brought us Clicky Clicky Draggy Droppy, and who is the PM for […]

I am sure that there were a few people who were eagerly waiting for the Power BI Desktop Update for October 2018. I sure was one of them and it was well worth the wait. Please read all the details …

Playing around with Microsoft Flow recently, I was reminded of the following blog post from a few months ago by Konstantinos Ioannou about using Flow to call the Power BI REST API to refresh a dataset…

I have heard this question come up now and then where someone wants to separate the names and columns seen by users from the names and users used in SSAS...

Connecting Excel do your Power BI Desktop database has many useful applications, for example you can use Excel to do some quick and advanced testing on the values of your Power BI model. Power BI D…

I have built several solutions over the years to enable business users to get at the data they need to do the analysis that is important to them. I would build cubes so that they could slice, dice and…

There is nothing worse than having a Power BI report that has 50% of the space taken up with slicers. When this happens, you only get half the page to visualise the actual data. But on the flip s…

I have been working with a customer on the implementation of Aggregations with Composite Models in Power BI and I have found that there are a few useful tips to assist you with getting it up and ru…

I was chatting to Phil Seamark (Power BI MVP and Author) recently and Phil suggested that it would be good to create a Power BI report that showed all Power BI Events around the world. The original id…

In this article, we will see how to combine different dimensions and facts inside a single matrix table visual.This approach helps us create fewer measures and tables, but at the same time, it provides us with greater design possibilities, like conditional formatting across the whole column even though there are different measures invoked inside the column. The previous would be impossible without this technique....

A couple of things have happened within the last few days. In short: We have a new promo video We published 3 Data Stories to the Power BI data stories gallery Our Partner Showcase solution has been approved and published on the official Power BI website That’s A LOT of info to digest, but let’s …

I’m at the PASS Summit this week, and in this morning’s keynote there was a demo of the newly-released Azure Data Studio – a modern, cross-platform tool for managing and querying…

It’s sometimes difficult to find things that Power BI can’t do. There always seems to be a solution no matter the task at hand. A little while ago I was wondering to myself if it was possible to embed a website inside of a Power BI report. My initial instinct was “Of course! But how?” It turns out that this is very