Why Every Finance Professional Should Learn Power BI (not just Excel)
Discover how Power BI helps Finance professionals automate reports, boost efficiency and uncover deeper business insights beyond Excel
Tag PowerQuery
What is Power BI and How Does It Work?
What is Power BI and How Does It Work? So the big question then…what is Power BI? That’s what we’re answering in this article, so that you can start to understand what it does and how it works and why…
How to fix a merge in Power Query
Why Is My Power BI Merge Not Working? Merging in Power Query, whether in Excel or Power BI, is one of the core skills for your average data transformationalist (is that a word?!) In essence, the purpose of a merge…
What’s the big advantage in using the Sharepoint Folder connector in Power BI?
1 BIG reason to use the Sharepoint Folder connection in Power BI What’s the main advantage to using the Sharepoint Folder connector in Power BI? BUSINESS CONTINUITY. The ability for essential reporting to carry on in a business while key…
How to bypass the Excel row limit
How can I bypass the Excel row limit of 1,048,576 rows Date.AddDays is a great function that allows us to add days onto a column of Date or DateTime values in the PowerQuery editor. Adding days onto a date value…
How to merge using the Left Anti join in PowerQuery
How can I use the Left Anti join function in PowerQuery? Date.AddDays is a great function that allows us to add days onto a column of Date or DateTime values in the PowerQuery editor. Adding days onto a date value…
How to get data from a PDF into Excel using PowerQuery
How to get data from a PDF into Excel using PowerQuery One of the questions I used to ask all the time as a finance analyst was ‘how can I get data from a PDF and put it into Excel?’…
You must be logged in to post a comment.