Power Query – How to get the output from a table as a value or an item
I was working on a customer’s data where I wanted to get the output from a table, but have it stored as a value or item. I am sure that in the comments there might be a possible way to do this more efficiently, but below is how I solved this challenge. As always it is best to work through…
Power BI RoundUp – Power BI Desktop May 2019 | Custom Navigation for Power BI Apps | Power BI Report Server May 2019 | Meet the community stars at MBAS | SQL Server 2019 SSAS CTP 3.0 | Trusted 3rd Party Connectors
Welcome back to another Power BI RoundUp! It has been a fair while and to be honest I have been extremely busy with a client planning for and looking on how to best leverage Power BI for their reporting requirements. Let’s get started with the latest updates. Power BI Desktop May 2019 Another month has come and gone and there…
Why do I have to pay for Power BI Premium features?
I generally see quite a lot of questions as to why certain features are only available in Power BI premium. In this blog post below, I am hoping that I can explain as to why there is a cost associated to them. Power BI Pro Let me start by saying when I log in with Power BI Pro, I am…
Power BI Premium Performance – Part 4 | How does Row Level Security affect performance?
In the third part of my blog series on Performance, this time I am going to see how Row Level Security will affect performance. RLS is an awesome feature when you want to ensure that only the relevant people can view their data and not see other data. Row Level Security (RLS) is where I can create roles which can…
DAX – Calculating the difference between 2 selections on a Slicer
Once again, I really enjoy answering questions on the Power BI Community, it keeps me challenged on how to find solutions to people’s requirements. This time the challenge was that a user on the forum was looking to calculate the difference between 2 selections made on a slicer. In this example the slicer was on a Product. Below is the…
Power BI Premium Performance – Part 3 | How does a dataset refresh affect performance?
In the third part of my blog series on Performance, this time I am going to show how a data refresh can affect performance. Below are the high-level steps as to what happens when you refresh a dataset The first step is it creates a blank copy of your existing dataset. It then loads all the updated data into this…
Power BI Premium Performance – Part 2 | Optimization of your Power BI Model
In the second part of my blog series on Performance I am going to show how to look to potentially optimize your Power BI Model. The biggest impact you can have to the performance of your model is if you can reduce the size of the model, it just means that everything will run that much faster, process quicker and…
Power BI RoundUp – Paginated Reports in Power BI Apps | Cache Settings for Azure Analysis Service
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 organisation to use. All the details are here: Paginated Reports now supported in Apps in Power BI Cache settings for Azure Analysis…
#PowerBI Premium Performance – Part 1 | How to use the new XMLA End Point to see how much memory your datasets are using
With the new XMLA end points, it opens a whole new world of possibilities with Power BI Premium. This is part 1 of a series that I am going to be putting together series on how to make sure when moving to Power BI Premium you can ensure that you get the best performance possible. In the future blog posts,…
#PowerBI RoundUp – April Desktop Update | Service & Mobile March 2019 Summary | New App Workspace Experience | Paginated Report Builder Available | New Power BI Regions in France and Korea | Industry Benchmark recognizes Microsoft’s Analytics | Create Machine Learning Models in Power BI | Enabling Cognitive Services & Auto ML in Power BI Premium | Presentation Mode in the Windows Power BI App
Well this week has been a BUMPER week of updates from the Power BI Team, there is a lot to get through. Because there are so many updates, I am not going to go into a lot of detail, but rather give you an overview, after which you can click on the links if you want more information. April Desktop…