Identity column feature is an excellent example of the "missing puzzle" in Microsoft Fabric. Hence, we still have to rely on some workarounds and "hacks" to get the job done. This article helps you choose the solution that will play to your strengths

As part of Microsoft Fabric, a new storage mode to connect from Power BI to data in OneLake has been introduced. Direct Lake it makes to possible to use your data from OneLake in Power BI without t…

When first connecting to Databricks SQL in Power BI , whether you use Partner Connect or manually enter your Databricks SQL warehouse info…

In this article, we tackle the growing issue of ‘report-specific objects’, dataset measures and tables created to fill specific report visual requirements, why they negatively impact self-service users, and best practices to mitigate this impact.

Over the last half year, I have been involved in many large migration projects from another BI tool to Power BI. All with a different setup, from Tableau, Microstrategy and from Analysis Services t…

PowerBI.tips is extremely happy to be part of, and contribute to, the Power BI Community. We’re constantly trying to think of new and interesting ways we can enhance the Power BI experience for eve…

With Bookmarks and Back functionality taking Power BI to new heights of interactivity, I employ a time-saving prefix when trying to keep various report objects straight. I add a short symbol at the…

Mark V SQL - Mark Vaillancourt: Data Nerd

You can now use natural language queries in Power BI Desktop, using Q&A

One of the really cool features contained within the PowerBI.com service is the ability to monitor how often your dashboard or report is being viewed. You’ll find this feature by opening up …

I have decided to write a series of blog posts about visual design concepts that can have a big impa...

In this video, Patrick shows how you can use bookmarks and selections to create interesting reports to show different aspects of your data. He also shows a very cool way to change between those select…

Dynamic TopN Reports via Slicers: Now you can click, slice, interact, touch (…dirty), and drill (dirtier!) with these reports to your hearts desire.

Even Very “Sophisticated” Reports/Dashboards are Often “Couch Potatoes” in Practice(They Sit There and Expect You to Do All the Work) Intro From Rob I’ve b

When we wrote the first installment of "Data Storytelling: The Ultimate Collection of Resources" the world was a different place. It was 2013 and we were all busy celebrating a new royal baby, adding the words "twerk" and "selfie" to our vocabularies, asking ourse

In the last two articles, we walked you through Q&A's basic linguistic capabilities and how you can optimize your model to best take advantage of them. Since those with short attention spans have long-since stopped reading, we can now safely...

Introduction By now, you've probably seen a demo of Power BI Q&A and may have played with one of our sample models. So at this point, you're probably thinking one of two things: Either you're amazed by how smart the system is...

Last time, we gave you the best case scenario for Q&A against a "raw" data import. However, in order to successfully understand the large swath of questions it is capable of interpreting, Q&A makes a number of fundamental assumptions...

BI@Microsoft is a program inside Microsoft IT which is responsible for the BI tools Microsoft employees use. This blog post will look at how we are driving rapid internal adoption of Power BI and influencing the Power BI product group so that it builds a product that meets the needs of large enterprise customers.

Over the past year or so, we

Do you want to connect to a Power BI Desktop Model from Excel or SSMS? Do you have Power BI Performance issues? Then this article is for you.

All this talk all the time about Big Data and Advanced Analytics is all well and good, in fact it is something I do most of my time. The technology is there and has great potential. The biggest que…

I recently found myself needing to do some Crystal Reports testing on a virtual machine. The tests were successful on my laptop but we use a  virtual machine running Windows Server 2008 R2 and…