My Latest Podcast with Rob Collie from P3 Adaptive
Excelerator BI
by Matt Allington
2w ago
Last week I again had the pleasure of being invited by Rob Collie to be on his podcast Raw Data by P3 Adaptive.  For those that are not familiar with my story, I identified Rob as a leader in the Power Pivot/Power BI space very early on (back in the [...] Read More ..read more
Visit website
Ways to Configure RLS in Power BI
Excelerator BI
by Nick Jeffries
3w ago
Level: Intermediate Why You May Want to use RLS Imagine you’ve just built a Power BI report filled with sensitive financial data. You want to start to share this data across the organisation but not everyone is allowed to see everything.  The CFO should be allowed to see everything, but [...] Read More ..read more
Visit website
My Journey as Microsoft MVP is Coming to an End
Excelerator BI
by Matt Allington
1M ago
As you may know, Microsoft has an MVP Programme where it acknowledges and rewards community leaders for their subject matter expertise and contribution to the community. There are many benefits of being an MVP including the recognition (leading to people understanding that you must be doing something right if Microsoft [...] Read More ..read more
Visit website
Slicer Values Don’t Clear after Changing a Second Slicer
Excelerator BI
by Matt Allington
4M ago
Have you ever had a situation where you have a slicer selection that “sticks”? You make a selection in a slicer, then make some changes somewhere else, but the first selection you made “sticks” when it is no longer valid? Take a look at this animated demo below to see [...] Read More ..read more
Visit website
Why Did Microsoft Rename Datasets to Semantic Models?
Excelerator BI
by Matt Allington
4M ago
In this article I’m going to talk about the recent change that Microsoft has made in renaming the underlying database used in Power BI from the term “dataset” to “semantic model” (or as I would call it, “semantic data model”). The Word “Semantic” Let me start by talking about the [...] Read More ..read more
Visit website
Data Modelling for DirectQuery
Excelerator BI
by Jason Cockington
10M ago
In my last article I introduced the three different connectivity modes that are available for Power BI to fetch data from a source, with a specific focus on when and where to use DirectQuery connections.  In this article I am going to go deeper and introduce the modelling aspects of a DirectQuery [...] Read More ..read more
Visit website
Sydney PUG Meetup – Ask Miguel Myers Anything
Excelerator BI
by Ramana
1y ago
On 12th April 2023, Iman and I hosted Miguel Myers as our special guest at the Sydney Power BI User Group.   Miguel is a visualisation guru from Microsoft and has worked there for many years.  He has recently been assigned as the Product Manager for Visualisations in Power BI, and [...] Read More ..read more
Visit website
Build a Power BI Paginated Report Online
Excelerator BI
by Matt Allington
1y ago
Back in April 2022, I wrote an article called Poor Man’s Paginated Reports. That article covered an easy way to create a paginated report without having to learn how to use paginated report builder. Sometime since then, Microsoft has released the ability to create a simple paginate report online inside [...] Read More ..read more
Visit website
Nesting Measures in Inforiver
Excelerator BI
by Matt Allington
1y ago
The Power BI Matrix visual is similar to an Excel Pivot table, however there are quite a few limitations in the Matrix. In the Power BI Matrix below I have put the product categories on Rows, Calendar Year on Columns and the measure [Total Sales] on Values. At this point, [...] Read More ..read more
Visit website
Five Essential Power Tools for Power BI Desktop
Excelerator BI
by Jason Cockington
1y ago
The External Tools ribbon is a feature that has been available in Power BI Desktop since the July 2020 release.  This feature should be considered essential to anyone who is regularly working in the Power BI space.    In this article I recommend my top five External Tools, that I [...] Read More ..read more
Visit website

Follow Excelerator BI on FeedSpot

Continue with Google
Continue with Apple
OR