Automatically remove empty columns and rows from a table in Power BI
Hi again. This is Maya (you can find me on Linkedin here), with my second post on DataChant: a revision of a previous tutorial. Removing empty rows or columns...
Tag: Excel
Split CamelCase headers in M (And a fix for the Record of Promises)
How many times did you have to work with tables that had headers like these? Client_ID, Transaction_ID, Product_Name,...
Text Obfuscation in Power BI and Power Query in Excel
Power BI and Excel offer a wide variety of collaboration and sharing experiences. In today's blog post, we will share a useful method to easily obfuscate /...
Removing/Selecting Columns – Pitfall #5 in #PowerBI and #PowerQuery
In today's episode of the Pitfalls Series (here), we will briefly discuss the fifth pitfall, which is one of the most common mistakes that you always do, when...
Analyze Salesforce Opportunities in Excel + Workaround for the login failures in #PowerQuery Salesforce connector
As promised here, in today's post I am sharing an Excel template that analyzes Salesforce Opportunities, and allows you, with a single click of Refresh All in...
How to Enforce Power Query/Power BI to Import Uncached Data from the Web
A Power Query Mystery I recently stumbled upon a mysterious Power Query behavior. A Power Query query was pulling data from an external Excel workbook that...
Sneak Peek: Analyze Salesforce Opportunities in Excel
As a special gift to you for the coming holidays, I am about to share a FREE Excel template that analyzes Salesforce opportunities. While the template is...
Automatically remove empty columns and rows from a table in Excel using Power Query
In today's tutorial, we will solve a very common challenge in Excel. You start with an Excel table and you wish to condense it by removing all the columns...
Clinton vs Trump – Whose campaign is more negative? Opponent-Mentions and Sentiment Analysis in Excel
Are You Ready for the Debate? Today is the US Presidential debate. It is also a perfect opportunity to hone our analytical skills and answer some of...
Sentiment Analysis in Excel & Power BI
Today I would like to kickoff a special series on DataChant blog - For the first time ever, we will incorporate Sentiment Analysis to our Excel workbooks...
