We have an enterprise job scheduler which is used to execute ETL jobs. The last step of the job scheduler is to refresh the Power BI data set. Here are the steps to do it. Create a Service account in your Azure Active Directory. Assign Pro license to the Service Account. Add the Service Account … Continue reading Scheduling Power BI Data Refresh using APIs
Category: This and That
SAP BW Connector for Power BI – Support for additional member properties
October update of Power BI Desktop was released a couple of days ago. One of the key feature update in this release is that the SAP BW Connector now supports additional member properties (attributes). Earlier version of SAP Connector exposed only text value of the BW object. To get additional member properties, we had to have … Continue reading SAP BW Connector for Power BI – Support for additional member properties
SAP BW Connector for Power BI – Entering Parameter values
With recent updates to Power BI Desktop there have been a lot of enhancements to BW connector. The most significant of them is the ability to filter parameters to display only those that are required. This is achieved by clicking on Show on the top right corner of the Navigator dialog and selecting Only required parameters. … Continue reading SAP BW Connector for Power BI – Entering Parameter values
Scaling Azure Data Warehouse using Azure WebJobs Scheduler
Following 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 … Continue reading Scaling Azure Data Warehouse using Azure WebJobs Scheduler
How to Publish Azure Data Factory Artifacts
Azure 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 … Continue reading How to Publish Azure Data Factory Artifacts
Enabling Power View in Excel 2016
In Excel 2016, click on File -> Options -> Add-Ins From the drop down select COM Add-ins and select Go… In COM Add-Ins dialogue, if Power View for Excel is not selected, select the check box and click OK Notice that enabling the Add-In does not provide the ability to create a Power View report … Continue reading Enabling Power View in Excel 2016
New (but yet to be released) Power Map Features – Check out this video
Bing vs. Google
This is an off-topic post that will not talk about BI at all.Yesterday, I wrote a quick post about using the Earlier() DAX function to generate an index column in Power Pivot. There is nothing earthshattering in that post; the reason I decided to write it was because I tried to do a web search on the … Continue reading Bing vs. Google
Running Windows 8.1 on MacBook Pro 15 with Retina display
No, there is no mistakes here, my new official working machine is now a MacBook Pro 15 with Retina display running Microsoft Windows 8.1. I am very surprised myself with myself, but at this point, I totally understand why Microsoft decided to do what it did with its own line of hardware devices because offerings … Continue reading Running Windows 8.1 on MacBook Pro 15 with Retina display
Microsoft Surface RT review, sort of in a context of Microsoft BI
First, I have to explain why I am writing this review when so many websites have already covered the product – the only thing that I will cover that others haven't is what features of Microsoft BI stack run on Surface and what don't. Let's get through the bad stuff first. I don't know if … Continue reading Microsoft Surface RT review, sort of in a context of Microsoft BI
business intelligist 