Latest Power BI and AI articles from RADACAD team
“In the last post, you have seen how we can create a chart by importing data from SQL Server 2017. By doing this, we have a reliable code for drawing chart. Now, we sure our codes work fine, we can put the codes in SQL Server 2017. In this post, I am going to show Read more about R Chart into SSRS (ggplot2 package in SQL Server 2017)-Part 2[…]
Implementing a Power BI solution is not just about developing reports, creating a data model, or using visuals. Power BI, like any other technologies, can be used in a correct, or incorrect way. Any technology can be used more effective if it harnesses the right architecture. A right architecture can be achieved after a requirement Read more about Power BI Architecture Guidelines[…]
In this and next post, I am going to show you how to connect to SQL Server to get data from there, then create a table chart using ggplot2 package inside SQL Server 2017 and then show the chart in SSRS. there are multiple steps for that we need to follow Get data and create Read more about R Chart into SSRS (get data from SQL and create ggplot chart in R)-Part 1[…]
Power BI Report Server can host Power BI reports on-premises, and you’ve learned about it in the previous post. There is another integration between SQL Server Reporting Services and Power BI service; this integration brings tiles from SSRS reports pinned to a Power BI dashboard with scheduled updates from SQL Server agent. The integration of Read more about SQL Server Reporting Services Integration with Power BI[…]
If you work for an organisation that stores thumbnail images of staff inside Active Directory, you can probably access these and incorporate the images in your Power BI Reports. This is a great way of making an internal staff report look fantastic – and it’s easy! Step 1. Click Get Data from the Home tab Read more about Add Photos to Power BI from Active Directory[…]
In the last post, I have explained, how to use AzureML package with the aim of exploration of Azure ML studio experiments and datasets inside R studio environment. moreover how we can use this package to upload a dataset from R studio into Azure ML has been shown. In this post, I am going to Read more about Azure ML Package-Publish a Web service from R-Part2[…]
I am seating in the front row of keynote for Data and BI Summit 2018 in Dublin ran by Dynamic Communities. There will be some great announcements today about upcoming Power BI features. Here in this blog post I will list these features. Incremental Refresh The most wanted feature of Power BI for refreshing data Read more about Power BI Announcements in Data&BI Summit 2018 Dublin Keynote[…]
There is a possibility to run R codes and Python in Azure ML. In this short post, I am going to show you how we can run an R codes to show some charts in Azure ML with ggplot2 package. I have a dataset about the dairy product in the USA. this dataset holds Read more about Run R codes in Azure ML[…]
Part 1 of 3 Using RANKX in calculated measures Part 2 of 3 Using RANKX in calculated columns This article concludes my epic series detailing how to use the RANKX function in DAX. In this episode, Frodo finally reaches Mt. Doom and successfully uses RANKX to find the best path into the mountain and complete Read more about How to use RANKX in DAX (Part 3 of 3 – The Finale)[…]
Azure ML Package is another Microsoft related package that allows you to upload and download datasets to and from AzureML, to interrogate experiments, to publish R functions as AzureML web services, and to run R data through existing web services and retrieve the output. Azure ML in R studio The first step- Installation First, you need Read more about Azure ML Package-Part1[…]