Power BI

This post discusses two methods of receiving an alert when a tenant setting has changed in the Power BI Service: one using Cloud App Security, and the other using the M365 Security & Compliance Center.

I recently came across an interesting problem regarding how you can show the sum of values of certain selected categories as separate bars in a bar chart – but with the sum of all the non-sel…

How to set up dynamic page navigation and drillthrough in Power BI.

Power BI Bookmarks, the secret behind many sleek reports, It revolutionised the entire PBI Report design approach. Initially, Bookmarks were portrayed more as some saved views, which can be used…

Using the XMLA endpoint, the Power BI Premium service now includes the capabilities of SQL Server Analysis & Azure Analysis Services combined with newer data modeling capabilities of Power BI. …

I see lots of chatter on Twitter and other media about the use of “small multiples” as a great way to communicate information across different subsets of data – yes Jeff Weir(d), that means you. I thought I would write a quick article about the concept to draw your awareness [...]Read More »

In the April release of Power BI Desktop the Power Query Query Diagnostics feature was enhanced so that you can now return performance counter data. As the blog post says: When you run performance …

Merging (or, in SQL terms, joining) tables in Power Query is a common cause of refresh performance problems. I’ve often wondered whether there’s anything you can do to optimise the perf…

Let’s say you have a Power BI file connected to an Analysis Services machine. Then you want to change the data source to PowerBI.com using [...]

We are excited to announce Direct Query support (Preview) for Power BI dataflows.  You can now connect directly to a dataflow without first requiring to import the data into a dataset. 

In this article, we share an idea to reduce the friction in using Power BI, by extending the DAX language with new visual calculations. At SQLBI, we teach D

Reading Time: 4 minutes Postman is a valuable tool to work with APIs, especially when testing and making ad hoc requests outside of an automated production solution. In terms of where a Power BI developer may find Postman useful, it sits somewhere between the documentation’s “Try It” functionality and a more production-worthy solution incorporating tools like Azure DevOps, Logic…

It can sometimes be frustrating to work with slow data sources or complex Power Query queries in Power BI Desktop: you open the Power Query Editor, make some changes, click Close & Apply and th…

This article shows how to use DAX and conditional formatting together to highlight the minimum and maximum values in a matrix in Power BI. Conditional forma

This article explains how to show different customers with the same name in a Power BI report by using zero-width spaces, thus simplifying the presentation

It’s been a while since I typed up a blog post but life, even in the midst of a pandemic, has been busy and crazy. As you can imagine, that customers I support in the education industry have …

In the last post, I have explained how to work with Q&A visual . There is a way to define terms for the Q&N visual. There are two main terms Adjective Define an explanation for a column using a Measure. We able to define a measure as adjective for each columns of data. Columns Define…

If you have been using dataflows, and you have the return value of a query as something which is not in the form of a table, such as a record, list, or value. then you have seen that the dataflow automatically converts them all to tables. There is an explanation about it, and a method…

We are happy to announce the public preview release of Power BI Deployment Pipelines, a new and improved way for BI teams to manage content lifecycle within Power BI Premium.

Today, we wanted to announce our roadmap for workspace upgrade so you can plan ahead.  We also announce in this post our classic workspace deprecation plans. If you’re a Power BI admin or workspace admin, this is a must read.

In my experience working in IT industry from early 2000 one aspect of dealing with data that is always taken very seriously is data governance. For many years the industry learnt how important it is to have a data governance process in place to keep your data safe and healthy so you get the most … Continue reading Introducing Power BI Governance and Adoption Good Practices Series

This month we are incredibly excited to announce a new visual personalization feature to allow your end-users to explore and personalize visuals all within the consumption view of a report! Check out the full blog post to learn more.

We have a ton of great updates this release! We’re excited to announce a new visual personalization feature to allow your end-users to explore and personalize visuals all within the consumption view of a report! Also this month, if you’re interested in fast refresh scenarios, you will find these new features very useful: change detection for page refresh and support for relative time filters in minutes and hours. On top of this, we are releasing several other features, including rectangular lasso select across visuals, conditional formatting for totals and subtotals, Direct Quer...

There was a very subtle but important change made in the April 2020 release of Power BI Desktop that you may have missed. Take a look in the format pane on the right in the image below – do you see it? Note the “new” function buttons? When I say [...]Read More »

If you’ve ever used DAX Formatter to format your DAX code and wondered why there isn’t an equivalent for Power Query/M, then wonder no more: the nice people at Power Pivot Insights in G…

If you’re working with large amounts of data in Power BI you may find that you have problems because: Your pbix file is very large You spend a long time waiting for refreshes to finish in Pow…

This month we are incredibly excited to announce a new visual personalization feature to allow your end-users to explore and personalize visuals all within the consumption view of a report! Check out the full blog post to learn more.

Welcome to the all-digital Microsoft Business Applications Summit 2020! As we kick off the event, we are excited to announce and showcase new capabilities to help our customers drive a data culture in their organizations.