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…
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…
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…
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…
#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…
#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,…
Power Query – How to extract data before and after delimiters
I had a requirement where I wanted to extract the data before and after the data as shown below. In order to do this, I created the following Custom Column with the syntax below. I did try and use the “Columns from Examples” but it…
Power BI RoundUp – Dataflows Generally Available | XMLA Endpoints | Azure Analysis Service available in Paginated Reports | Presentation Mode in Windows App | New Q&A Dashboard
After last week, where there were actually no new Power BI items to write about, the Power BI team sure made up for it in the past week. Please find all the updates below. Dataflows now Generally Available I have to give a big kudos…
Power Query – Replacing Column Names with spaces in Camel Case Notation
I was working with a table with quite a few columns where the column names were using Camel Case Notation (ThisIsMyColumnName), and I did not want to rename them manually. I used the following Power Query Code below to let it do the column renaming…
How to convert XLS files to XLSX so that they can be used in #PowerBI
I recently was having a challenge which we all have had when working with Power BI. The customer I was consulting to have all their data extracts saved in XLS (The dreaded XLS!) I thought that there must be a way to convert them quickly…