Power Query – A function to remove spaces within Text values
UPDATE: 19 Nov 2018 With the recent announcement of dataflows in the Power BI Service, I see more people will be looking to better understand and leverage dataflows by using the M language which is available in Power BI Desktop, Power Apps and Microsoft Flow. I had a great response to this blog post, and both Ted and Daniil had…
Power BI InfoGraphic Update – Sep 2018
It has been a few months since I have updated my Power BI InfoGraphic and with the speed at which this all changes and updates I have always had a challenge to keep it up to date. The following items have been added with links to more details: Composite Models Buttons Aggregations Comments in Dashboards New App Workspaces Geographic Distribution…
BI-RoundUp – Power BI (Sep Update for Power BI Desktop – Dashboard Comments – Community Contribution to PowerShell Cmdlets – Power BI PowerShell Cmdlets available in Azure Cloud Shell)
Welcome to another week of my Power BI Round Up. And as expected there is another massive Power BI Desktop Update. Power BI – September Update for Power BI Desktop As always I am going to over the new features and highlight what I think is really relevant in terms of what has been released. Reporting With the added support…
What runs under the cover when I open Power BI Desktop
I am always interested in what happens under the covers when I open Power BI Desktop. So I did a little digging and I got the inspiration from Macro Russo when he did his Webinar as well as presented at the Queensland Power BI User Group on “My Power BI report is slow: what should I do?” What happens when…
Review of new Features coming to Power BI by Oct 2018 – From Business Applications Summit
I was fortunate to attend my first ever Business Applications Summit in Seattle. I had the pleasure of sharing an Airbnb with Matt Allington, Phil Seamark and Miguel Escobar, it was great to spend time with these Power BI Legends. I also did meet a lot of people and got to chat with people in the Microsoft Power BI team,…
Using the Power Function.InvokeAfter to determine how long to wait between API calls
I have been working on a dataset which I will hopefully reveal soon, but part of that was that I was getting rate limited when making an API call. I found Chris Webb’s insightful blog post (Using Function.InvokeAfter() In Power Query) where he details how to use the Function.InvokeAfter. The one key piece that I personally found missing was how…
Power Query Pattern – Adding Spaces in Text within your data with Camel Case
In this week’s blog post, I created this Power Query Pattern, which I created to add in spaces for CamelCase text within a column. To get this to work for you, all that you do is need to make one change to the code. Below is what the data looked like Then I created the following Power Query Pattern below….
Power Query – Renaming Multiple Columns
I was working on a dataset where I wanted to change multiple column names using one step and not having to change them manually. Since there were over 30 columns this would be really time consuming. Below I detail how to complete this in the Power Query Editor, which will replace all the column names for me in one step….
BI-RoundUp – Power BI (On-Premise Gateway Update – Developer Community Update)
Here is this week’s BI-RoundUp. I am hopeful that by this time next week the latest version of Power BI Desktop will be released! Power BI – On-Premise Gateway Update By far the biggest news is the capability to use Custom Data Connectors in the Personal Versions of the On-Premise Data Gateway. The Power BI Team did indicate in the…
BI RoundUp – Power BI (March Desktop Update, Share Content with anyone via email, Persistent Filters, Mixed Reality App, Service & Mobile Summary for Feb, Data & BI Summit)
After getting back from the MVP Summit in Bellevue, which was an incredible experience the Power BI team has been extremely busy getting some great new features out the door. Which means there is quite a lot to cover in this week’s BI-RoundUp. Power BI – March Desktop Update Once again, I must repeat what I have said before, the…