Power BI

A practical example on how to properly combine / consolidate / append Excel Files stored in a Folder using Power BI / Power Query.

I have written a few articles in the past that toy with the ideas of changing visibility and text colour based on selection. I started to wonder if it was possible to make a visual appear (or not)…

There are tons of articles about advanced tips of Power BI modeling such as advanced DAX, and context transition. However, based on my experience with our clients, I realized there is a big gap in basic content. Hence, this article is going to cover the basic essentials of the relationship. Tips such as: What is…

Is your report plain or bland? Patrick shows you how you can easily make your Power BI report pop with a custom background. It’s as easy as just getting PowerPoint and drawing some shapes. Demo files: https://guyinacu.be/demofiles

Today, we're going to talk about Spark MLlib within Power BI. If you haven't read the earlier posts in this series, Introduction , Gettin...

<p>A quick note on two bite size features. Have you ever wondered why the Navigate function requires the second argument? For example: Navigate( Screen2, None ) Why not just default …

We launched the public preview of the Data Gateway administration feature on the Power platform admin center in January. This feature provides tenant admins with visibility into all On-premises dat…

Today we are pleased to announce Query Caching for Power BI Premium, which speeds up content loading by caching previously-used query results. The setting is applied at the dataset level so any rep…

SSRS is near and dear to my heart. My first book (“Microsoft Reporting Services in Action” published in 2004 by Manning) was on this subject and I became an MVP because of my contributions around SSRS…

We have rolled out a new high-level summary metrics experience in the Power BI Admin Portal . This new experience replaces the four summary tiles you previously saw : CPU, Memory thrashing, Memory …

<p>There is an icon in almost every app or website. A plus icon, a search icon, there&#8217;s even refresh icons on your browser you&#8217;re reading this blog in right now. The icon con…

As per the April 2019 update, Microsoft has introduced a data profiling capability in Power BI desktop. Data profiling helps us easily find the issues with our imported data from data sources in to Po…

<p>You can now see problems with triggers on the flow properties page &#8212; making it easy to find out why your flow isn&#8217;t triggering. There are nine new connectors this month in…

It is a common request, to have a form that is so long, that it needs to span across several screens, like a “wizard”. Fill out a few fields, click Next, fill out a few more, click Next, etc. In t…

Thanks for watching this week’s Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup134 2 Minute Tuesday: https://guyinacu.be/databrickserror Patrick’s tech video: https://guyinacu.be/modelview Adam’s tech video: https://guyinacu.be/powerbigetdata Sources DAX 101: Summing values for the total (@FerrariAlberto) Power Query Memory Usage, Dataflow Container Size And Refresh Performance (@cwebb_bi) Creating a Fiscal Saturday Calendar (@kpuls) Governance settings for Power […]

The API approach has been available for a long time, but now the autonumber is available through the config. Jonas Rapp’s autonumber solution in XrmToolbox has been absolutely one of the best…

Time to get excited – the full session catalog for Microsoft Business Applications Summit is here. Explore every breakout session and workshop coming to the conference, taking place in Atlanta, Georgia June 10 – 11, 2019. Get ready to flex your skills – and build new ones – with all things Power BI and beyond. … Continue reading “Live now, full session catalog for Microsoft Business Applications Summit 2019”

When Power BI dataflows were officially released a few weeks ago there was a new setting for Premium capacities mentioned briefly in the announcement blog post: Container Size. The blog post only says…

Just a short post today to share with you a permanent fix to something that has been annoying me (maybe you too – but then again I am easily annoyed :-) ). Edit: read the comments below fro…

E-mail subscriptions is one of the key features used by millions of SQL Server Reporting Services customers today. Our latest release for “New Feature Friday” is the support of Paginated Reports in…

Your query doesn't fold in Power Query or Power BI? Don't give up too soon and find out how to make it fold again. Query folding

Easy way to get Teams data (or other data from the Graph API) into Power BI without using a custom connector but Microsoft Flow instead.

Reading Time: 3 minutes One of the defining features of Power BI’s [paginated] Report Builder vs the current geospatial offerings in Power BI Desktop is the native support for ESRI Shapefiles. If you …

After the Azure Analysis Services web designer was discontinued per march 1 2019 – link – there is no official tool to do a move of a PBIX datamodel to Azure Analysis Service. But by using a few diffe…

Import vs. DirectQuery vs. Live connection. Which do you choose and why in Power BI? Adam looks at the three options when creating reports in Power BI Desktop. DirectQuery in SQL Server 2016 Analysis S…

Here is another weeks Power BI RoundUp, and there is still a lot going on! Paginated Reports in Power BI Apps As you can see above paginated reports are now available when you create an app for your o…

<p>Lots of debuggers allow you to see the value of an expression simply by selecting it in the source. You&#8217;ll recognize an example immediately: Wouldn&#8217;t it be gre…

The full credit for this goes to the Guy in the Cube for his video where Adam talks about how to fix direct query to Azure Databricks models deployed to PowerBI.com . Unfortunately, this issue also af…

Patricks walks through what you can do with the Power BI Desktop Model View. From bulk operations to organizing your relationships in the Power BI data model, there are a lot of great things.