Faced this issue a few minutes back and it has to do with the local system settings and firewalls in particular. Here are the steps I tried in the order I tried them First checked if I was typing in the password correctly. Checked if the security group for the instance has been modified to… Read More »
In this post we cover how to work with multiple files of type CSV when loading into Power Query. Very often we have a set of data provided in a specific format on a daily / weekly basis on which we want to perform the analysis using PowerBI. Combing the different files into a single… Read More »
One the best parts of using analytics engines are their ability to understand dates and other types of hierarchies. As human being we use time as a core aspect in our measurement of change. Things like sales week on week or week over week. Year till date, month till date are all important calculations we… Read More »