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
Category: This and That
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.
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
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
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
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
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
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
Microsoft is expected to make a number of very important announcements at the upcoming SQL Pass conference in Seattle… If you are on the fence about attending it this year, I would definitely recommend attending this event.