Since Power BI does not have a native connector to SAS yet I decided to write this blog and walk you through using R to read data from your *.sas7bdat files. I will assume that the reader does not have R installed so I will walk you through all the steps necessary to get this going. Step 1 – Install
Read moreFollowing link looks into various options available to scale compute power in Azure SQL Data Warehouse. Next question that one would ask is, how do I automate the capability to scale the compute power. In this article, I answer the question using Azure WebJobs. Azure WebJobs provide an easy way to run scripts or programs as background processes in the
Read moreAzure Data Factory artifacts can be edited and deployed using the Azure portal. However, as an enterprise solution, one would want the capability to edit and publish these artifacts using Visual Studio. Let’s check are options available to publish using Visual Studio. Assuming you have the created a Data Factory project in Visual Studio and extracted the artifacts to this
Read moreWorked with @nnarasimha to create a mobile app which embeds Power BI tiles in it. Code can be downloaded from Github https://github.com/nikilprabhakar/Integrating-PowerBI-Tile-in-a-mobile-app
Read moreHere is a common requirement that I have come across: “I want the Date slicer to automatically select current date without me having to manually change the slicer”. Here is a way to do that. We have a Power BI Desktop report that was created on April 10th 2016. When the report was created, we set the slicer to 4/10/2016.
Read more
One of the most anticipated features that we all have been waiting for has now been finally released in Power BI by Microsoft. After a dataset has been published to Power BI, it can now be secured. This feature is still in preview and is a little bit rough around the edges as it requires you to re-implemented all
Read more
In a not particularly surprising move, SAP’s knee-jerk reaction to its a dramatic fall in Gartner BI Rankings has resulted in a yet another acquisition. I was wondering about this scenario in my previous post about Tableau’s stock taking a dive, where I pondered whether SAP had enough cash to acquire the company. It seems like the answer is
Read more