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…
Power BI RoundUp – Service & Mobile update for Feb 2019 | On-Premise Gateway Update | Update on New App Workspaces V2 | Power BI Embedded at Power Platform Summit | Multivariate reporting
Welcome to this weeks Power BI RoundUp, it is a little late this week. I have been fortunate enough to make it to Redmond and attend the MVP Summit, it was once again an amazing summit! Here are this week’s updates, which might be a…
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…
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…
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…
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…
How to get one table to refresh in a Power BI Data Model
I was recently working on a large Power BI Data Model and I did not want to refresh the entire data model for my updated dataset to come through. This would mean refreshing the large Fact table with a few million rows and a complex…
Power BI RoundUp – End user filter export capabilities | Template Apps | Developer Community Update
Welcome to another Power BI RoundUp, and fortunately this week has been a quieter week, which has worked out well because I have been attending the Difinity Conference in New Zealand where I have both presented on Dataflows. I also attended a lot of great…
Do you know how to use Multiple Disconnected Slicers in Power BI?
I had previously blogged Power BI – Using a Slicer to show different measures where I showed the steps on to have a different measure based on a slicer selection. I got a few comments from that blog post, where people were asking if it…