SAP HANA Connector – Multidimensional or Relational mode

SAP HANA connector in Power BI is available in two modes - Multidimensional and Relational. Let's look at the Pros and Cons of both these modes. Pros of Multidimensional Mode: Performance is good. Can connect to multiple data sources in Import mode. Parent child hierarchy is supported. SSL is supported. Cons of Multidimensional Mode: Composite … Continue reading SAP HANA Connector – Multidimensional or Relational mode

Improving authoring experience for SAP Direct Query reports

The experience while authoring reports using direct query for SAP data source is sometimes not optimal. Every click sends a query to the data source and we have to wait for the visuals to refresh.... Here is how I work around this issue. It's not ideal but makes authoring experience a little better. From the … Continue reading Improving authoring experience for SAP Direct Query reports

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

Power BI Tutorial: Row Level Security on Parent Child Hierarchy

EDIT: I recorded a detailed video on how to work with Parent Child hierarchies in Power BI: https://businessintelligist.com/?p=2603 In the last post, I talked about flattening parent child hierarchy. Building upon that - the next question is how to make sure that an employee has access to only his/her data and that of the employee(s) … Continue reading Power BI Tutorial: Row Level Security on Parent Child Hierarchy

Power BI Tutorial: Flatten Parent Child Hierarchy

EDIT: I recorded a detailed video on how to work with Parent Child hierarchies in Power BI: https://businessintelligist.com/?p=2603 I have been working with SAP data source lately. And in SAP dimensions, parent-child hierarchy is very common and there is a need to flatten it in Power BI. A common parent child hierarchy is an employee … Continue reading Power BI Tutorial: Flatten Parent Child Hierarchy

Power Shell script to load data in to Data Lake Store

In an earlier post, we talked about self-service process to hydrate the Data Lake Store. We also mentioned the need to use Power Shell to load data files larger than 2Gb. Here is the Power Shell script: Provide your credentials to login to Azure: $MyAzureName = "<YourAzureUsername>"; $MyAzurePassword = ConvertTo-SecureString '<YourAzurePassword>' -AsPlainText -Force; $AzureRMCredential = New-Object System.Management.Automation.PSCredential($MyAzureName, … Continue reading Power Shell script to load data in to Data Lake Store

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