Recursive functions are a topic that I rarely come across.
To give you some perspective, the instances that I’ve needed recursive functions can be counted with just 1 hand.
This is one of those situations where a recursive function is probably the best way to go.
Big thanks to NicoPer who posted this question on the Official Microsoft Power Query forum.
Motivated by one of the latest videos from the MSFT guys behind Guy in a cube:
where they talk about one of the hidden secrets behind Power Query / Power BI, I wanted to talk about another one of those hidden gems inside Power Query / Power BI that is not completely visible or intuitive for most folks when they start using the tool.
Hey! This will be a short post just to let you all know that I’ll be speaking for the first time ever in a US based event later this July – the Microsoft Business Applications Summit 2018 Here’s an excerpt of my session (level 200): The Name of the session: Alberto Ferrari used to do […]
The results are in! Let’s find out which tool is better for the average Business Analyst based on the 3 scenarios that I showcased a few weeks ago here.
I was able to get in touch with the Product Team from Microsoft’s Power Query and also the one from Trifacta’s Wrangler. I tried getting in touch with the Tableau folks, but they never replied to my emails. Luckily, someone within Tableau’s Sales team did see my videos on YouTube and was able to give me a more refined view of what Tableau is capable of. Big thanks to everyone who helped me along the way through forum responses and multiple emails!
We’re going to break this down by each scenario and then we’ll tally up the results to figure out who’s the winner.
The latest version of Power BI Desktop came out with a new Web Connector specifically designed for Web Scraping Scenarios. in this blog post I’ll try to go deep into how this new experience works and how you can take advantage of it.
Before we move forward, you’re gonna need the latest version of Power BI Desktop (May 2018 for me) and also enable the Preview feature in the Options window:
I want to find out how many books are out there that have anything to do with Power Query. I want the reviews that go with them, the name of the authors, when they were released and, of course, the names of these books.
The best place to find this information is probably Amazon. So I went on Amazon and did a quick search using the keywords “power query”.
