Category: Power BI from Rookie to Rockstar

Interactive Charts using R and Power BI: Create Custom Visual Part 1

Posted on by Leila Etaati

I am so excited about using Plotly packages in Power BI. So What is Plotly: is an R package for creating interactive web-based graphs via the open source JavaScript graphing library: https://plot.ly/r/getting-started/ this feature has been added recently and had been announce by Christian Christian Berg in Data insight summit 2017. I started to search about Read more about Interactive Charts using R and Power BI: Create Custom Visual Part 1[…]

Integrate Power BI into Your Application: Part 4 – Refresh Data Set

Posted on by Reza Rad

Power BI REST API is not just for embedding content or getting list of dashboards and reports. It also has many functions to work with data sets, gateways, and data sources. As one of the many exciting features of that; you can easily refresh a data set from an application. you can refresh it as Read more about Integrate Power BI into Your Application: Part 4 – Refresh Data Set[…]

Integrate Power BI into Your Application: Part 3 – Embed Content

Posted on by Reza Rad

In the part 1, you learned how to register an application to be able to interact with Power BI service and Azure environment. In the part 2, you learned how the authentication process works and how you can get the access token. In this part, I’m going to explain what is the process of embedding Read more about Integrate Power BI into Your Application: Part 3 – Embed Content[…]

Integrate Power BI into Your Application: Part 2 – Authenticate

Posted on by Reza Rad

In the part 1, you learned how to register an application to be able to interact with Power BI service and Azure environment. In this part, I’m going to explain what is the process involved after that in order to authenticate through your application into Azure Active Directory. This step is important step before doing Read more about Integrate Power BI into Your Application: Part 2 – Authenticate[…]

Integrate Power BI into Your Application: Part 1 – Register your App

Posted on by Reza Rad

Power BI Embedded, which I have written about it previously, brings the power of Power BI into your application. Power BI Embedded Recently had major changes. If you remember from my previous post, there were many limitations in the type of content you can embed into your application and the ways of interacting with it, Read more about Integrate Power BI into Your Application: Part 1 – Register your App[…]

Exposing M Code and Query Metadata of Power BI (PBIX) File

Posted on by Reza Rad

Power BI Desktop file stores many metadata information in it, one of the most important piece of information stored there is Power Query M scripts. It is always easy to open a PBIX file and realize the queries in Query Editor Window. However, if you have many queries and you want a way to get Read more about Exposing M Code and Query Metadata of Power BI (PBIX) File[…]

Visualizing Data Distribution in Power BI – Histogram and Norm Curve -Part 2

Posted on by Leila Etaati

In the Part 1 I have explained some of the main statistics measure such as Minimum, Maximum, Median, Mean, First Quantile, and Third Quantile. Also, I have show how to draw them in Power BI, using R codes. (we have Boxplot as a custom visual in power BI see :https://powerbi.microsoft.com/en-us/blog/visual-awesomeness-unlocked-box-and-whisker-plots/ ). However, to see the data Read more about Visualizing Data Distribution in Power BI – Histogram and Norm Curve -Part 2[…]

Power BI Premium. Is It For You or Not?

Posted on by Reza Rad

There were many announcements earlier this month about Power BI. One of them which was and still is the breaking news of all is Power BI Premium. Many of you already know that it is a new licensing plan, but how it works? Is this a licensing plan that works for you or not? What Read more about Power BI Premium. Is It For You or Not?[…]

K-mean clustering In R, writing R codes inside Power BI: Part 6

Posted on by Leila Etaati

In the previous post,I have explained the main concepts and process behind the K-mean clustering algorithm. Now I am going to use this algorithm for classifying my Fitbit data in power BI.   as I have explained in part 5, I gathered theses data from Fitbit application and I am going to cluster them using Read more about K-mean clustering In R, writing R codes inside Power BI: Part 6[…]

Variable Width Column  Chart, writing R codes inside Power BI: Part 4

Posted on by Leila Etaati

In the part 1, I have explained how to use R visualization inside Power BI. In the second part the process of visualization of five dimension in a single chart has been presented in Part 2, and finally in the part 3 the map visualization with embedded chart has been presented. In current post and next ones I Read more about Variable Width Column  Chart, writing R codes inside Power BI: Part 4[…]