Power BI supports mobile devices through Power BI app for Android, Windows Phone, and IOS. Dashboards of Power BI can be seen nicely in mobile devices. However there are some difficulties to get a mobile report up and running in a way that it be useful for mobile users. In this post I’ll share some Read more about Tips for Mobile Friendly Report Development with Power BI[…]
When you work with data it is normal that you apply numeric calculations. Numeric calculations in Power Query depends on the nature of data returns different results. One of the most error prone calculations is division. Power Query behave differently when you divide a number by zero, zero by zero, number by null, and non-numeric Read more about Make Your Numeric Division Faultless in Power Query[…]
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[…]
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 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[…]
You have seen previously how we can use output of Azure ML model in a Power BI and visualize it with SandDance. In this video you will learn how to use R script as a source in Power BI desktop. Watch the video below;
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[…]
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[…]
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[…]
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[…]