Embedding Word Documents into new App Experience within #PowerBI
I was recently fortunate enough to go to the Microsoft Business Applications Summit where I had a great experience. One of the things that they did talk to, was creating links within the New App Experience which could link to other web pages or documents. This is really an awesome feature, and it enables users to stay within the App…
Review of new features & Announcements for #PowerBI – From the Microsoft Business Applications Summit
I was once again very fortunate to make it across to the Microsoft Business Applications Summit in Atlanta. I had 3 sessions which I presented at, and they went well. It was great to meet new people (some of whom I had only read their blog posts or viewed their videos) and reconnected with existing people. As I did last…
Power BI Premium Performance – Part 5 | How much memory will the PBIX consume?
This was something that I thought I had covered off already and was one of the key messages that I wanted to get across when looking to move to Power BI Premium. It can be quite confusing when always thinking about the size of a PBIX file being smaller than 1 GB and then moving to Power BI Premium where…
Power BI RoundUp – Enhanced attachment support for Paginated Reports
It appears that this week the good people on the Power BI team are busy working away to release some awesome new features next month. Below are the latest updates, I hope you enjoy the read! Enhanced attachment support for Paginated Reports As you can see from above there is now enhanced support for attachements that are sent as part…
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…