by Gil Raviv | Nov 23, 2016 | Data Chant
In case you missed this important functionality in Excel 2016, today’s short blog post is written to raise some attention to a wonderful feature. You can write VBA code or PowerShell scripts to automate the creation of queries, change their M expression and copy...
by Melissa Coates | Nov 18, 2016 | SQL Chick
Today I noticed there are a LOT more settings available in the Power BI Admin Portal than the last time I checked. Here are all of the choices currently available: This post first appeared...
by Gil Raviv | Nov 16, 2016 | Data Chant
Following my last post here, Imke Feldmann, author of THE BICCOUNTANT, proposed a refined version for the solution. While my original solution is simpler for users who are reluctant of manipulating Power Query (M) expressions, Imke’s solution is simpler for advanced...
by Gil Raviv | Nov 15, 2016 | Data Chant
Follow Me In today’s blog post we will learn a neat Power Query trick that is extremely useful in improving refresh time on certain Web API calls (Like Yahoo Finance, Quandl and Twitter). This post first appeared...
by Gil Raviv | Nov 6, 2016 | Data Chant
With only three days until the US Presidential Election, here is a Power BI report that extracts Trump’s and Clinton’s key phrases from their Facebook status updates during the race. In the upper WordCloud visual the most used phrases are bigger. In the lower...