#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…
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 did not work, because in my actual dataset some columns did not have the “(Data)”…
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 to the Power BI team, to not only now having this as Generally Available, but…
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 and putting in the space for me. Thanks to @Excel_City for assisting me in finding…
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 and easily, which I found after Googling ( I honestly cannot find the link to…
Power BI RoundUp – Desktop Update for March 2019 | Easy access to AI | Azure B2B Guest users can Edit content | Webinar on Using App-only Authentication
Finally, we have another fantastic Power BI Desktop update, as well as a host of other updates from the past week. There is a lot to go over so let’s get into it. Power BI Desktop Update for March 2019 There has been yet another great release of Power BI Desktop, as always please find the details below which I…
When working with long measures in #PowerBI, it is easier to create them in the Data View
I have been working with a lot of DAX at the moment and the new DAX area is awesome. What I have found at times when working in the Report View, is that when I edit the DAX measures, I sometimes have to click on the arrow multiple times in order to get it to back up. This can be…
Power BI RoundUp – Dataflows Data Lineage | MBAS 2019 | On-Premise Data Gateway Update | Colour Theme Survey
Hi there, another week, another Power BI RoundUp with more awesome features from the Power BI Team Power BI – Dataflows data lineage When you are using dataflows there now is an option to view the data lineage. What this means to me is a visual representation of where and how your data is flowing within your dataflows. This is…
How did I use the new Rounded Borders feature in #PowerBI Desktop to make shaded charts
In this blog post below, I am going to show you how I used the new Rounded Borders feature to create shaded charts with rounded borders as shown below. I used the new Rounded Borders feature that was released Power BI Desktop – Feb 2019 Rounded Borders This is what it looked like once I had completed the following steps…