Schedule Refresh Local Files on Power BI Web Site

I get this question asked in webinars, speakings, and comments on my blog posts that Is it possible to use a local file as a source in Power BI and schedule that to be refreshed? The answer is Yes, of Course. You can host your files locally or on a server on premises, and then Read more about Schedule Refresh Local Files on Power BI Web Site[…]

Meetup Data Source for Power BI

There are many SaaS (Software as a Service) data sources for Power BI, such as Mailchimp, SalesForce, and etc. However I haven’t found anything for Meetup. Meetup on the other hand is a data source that event organizers such as myself use mostly. In this post I will be using Meetup API to connect from Read more about Meetup Data Source for Power BI[…]

Power BI Desktop May 2016 Update; Quick Check

Power BI Desktop May 2016 Update is out now, and there is still no official announcement in Power BI blog for it, however Koen already posted a blog post about it. Just to name a few major updates; Conditional Formatting, Quick Calc, and Three new standard measures. Here are my first glance view of these Read more about Power BI Desktop May 2016 Update; Quick Check[…]

Power Query; Convert Time Stamp to Date Time

Power Query has number of Date and Time functions that convert values to date and time. However I haven’t found a function that converts a timestamp value. Fortunately it is easy to calculate a date time from a timestamp value. In this post I’ll explain an easy way of converting timestamp to date time. To Read more about Power Query; Convert Time Stamp to Date Time[…]

Azure Machine Learning with Power BI SandDance Visualization

You’ve seen a number of custom visualizations of Power BI that we’ve used in Power BI online book previously. In this post you will learn through a quick video how SandDance custom visualization of Power BI can be used to visualize clustering result set of an Azure Machine Learning model. In this video I’ll start Read more about Azure Machine Learning with Power BI SandDance Visualization[…]

Data Preparation is the Keystone – Free Webinar

Join me to learn about Data Preparation with Power Query and Power BI. This free webinar hosted by Power BI team and I will speak about techniques in Power Query that helps you transform the data and prepare it in the way required for your business. Expect many demos in this session from Power Query Read more about Data Preparation is the Keystone – Free Webinar[…]

Slides and Materials for PASS BA 2016 Conference

I have to first and foremost thanks to all attendees to my session at PASS Business Analytics 2016 conference, It was pleasure to have you all. Some of you mentioned that you are already using some contents from my blog which is great, and I’m humbled to hear this. I’ll definitly do more effort to Read more about Slides and Materials for PASS BA 2016 Conference[…]

Power Query Not for BI: Event Date and Time Scheduler – Part 3

Previously You have seen in Part 1 and Part 2 of this series, that how you can use Power Query to do data transformation and turn the result of event date/time scheduler of timeanddate.com website to a better format. We’ve used number of basic transformations, and some functions such as Table.Transpose to fetch desired output. Read more about Power Query Not for BI: Event Date and Time Scheduler – Part 3[…]

Power Query Not for BI: Event Date and Time Scheduler – Part 2

In first part of this series I’ve explained that Power Query can be used for non-BI scenarios, and here is a real-world use case example; Creating an event date and time scheduler which consider multiple time zones. In previous post you’ve learned how to use Power Query to do some data mash up to build Read more about Power Query Not for BI: Event Date and Time Scheduler – Part 2[…]