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

In the last two posts (Part 1 and 2), I have explained the main process of creating the R custom Visual Packages in Power BI. there are some parts that still need improvement which I will do in next posts. In this post, I am going to show different R charts that can be used Read more about Interactive Charts using R and Power BI: Create Custom Visual Part 3[…]

Dynamic SQL Using Power Query

Every so often I find myself needing to import data, but only want data relevant to values already existing in my data model.  This is common where I build smaller models based on a subset of fact or transaction records.  Rather than bring in entire dimension tables, I may only need the dimension records that Read more about Dynamic SQL Using Power Query[…]

Integrate Power BI into Your Application: Part 5 – Data Source Management

New REST API of Power BI is revolutionary. In addition to embedding content in Power BI, ability to refresh data set from API, it also gives you many functions to work with Gateways and Data Sources. With this API, you can set up new data sources, clone data sets, check the credentials of a data Read more about Integrate Power BI into Your Application: Part 5 – Data Source Management[…]

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

In the last posts, I have explained the main process of creating R custom visuals. In this post I am going to show how to: 1- Have more custom visuals 2- Different charts that we can have in Power BI 3- Explain some issues Have more custom visuals to have more R visuals, it is Read more about Interactive Charts using R and Power BI: Create Custom Visual Part 2[…]

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

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

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

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

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[…]

Neural Network R codes in Power BI Part2

In the last post, I have explained the main concepts behind the neural network, In this post I will show how to apply neural network in a scenario in R and how to see the results and hidden layers in a plot. For this post I got some great example from [1]. Scenario: Concert has Read more about Neural Network R codes in Power BI Part2[…]

Neural Network Concepts Part 1

In this and next one, I will share my understanding on Neural Network and how to write the related R code inside the Power BI. First, in this post I am going to explain what is main concept behind the Neural Network and How it works .The video https://www.youtube.com/watch?v=DG5-UyRBQD4&spfreload=10 helped me  a lot to get better Read more about Neural Network Concepts Part 1[…]