In this blog post of Mobile friendly Power BI report development series I would explain how to design dashboards for mobile devices. Fortunately this has come right at the time of the recent update on Power BI service with ability to design dashboard page specifically for mobile device. The dashboard design for mobile does work Read more about Dashboard Design for Mobile Power BI[…]
You can define Row Level Security in Power BI itself, However sometimes you do use SQL Server Analysis Services Tabular as the source for Power BI through Live or DirectQuery connection. SSAS Tabular allows you to create same type of Row Level Security. So it would be much better to use Row Level Security defined Read more about Row Level Security with SSAS Tabular Live Connection in Power BI[…]
I have mentioned previously that one of the ways to step beyond Power BI 10GB limitation is to use Power BI with Live Connection. In this post I will explain in a full step by step walk through how to use SQL Server as a DirectQuery or Live source for Power BI, and how to Read more about Step by Step Walk through: On-Premises Live SQL Server Connection with Power BI Enterprise Gateway[…]
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[…]
As I mentioned earlier in Power BI online book, Power Query is a functional language. Knowing functions is your best helper when you work with a functional language. Fortunately Power Query both in Excel and Power BI can use shared keyword to reveal a document library of all functions. I’ve written about shared keyword almost Read more about Power Query Library of Functions; Shared Keyword[…]
In previous videos you’ve learned that we can demonstrate R visualization in Power BI, In this video you will learn how R visualization is working interactively with other elements in Power BI report. In fact Power BI works with R charts as a regular visualization and highlighting and selecting items in other elements of report Read more about Interactive R Charts in Power BI[…]
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 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[…]