This sounds easy. In this video I prove to you it is not that straightforward. You need to know the trick to split the date field in Power Query. I took hours to figure this out. The video also shows you how to use your Power Query from Power BI to retrieve data directly from Web URL as well as Windows Azure SQL Database.