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

PowerApps – Navigate between screens

An app typically has more than one screen and we need the capability to navigate it. PowerApps has two functions, Navigate and Back that helps with navigation. Let's check out how these functions work. Download the App from here. Select Next button on the WOD screen. From the properties section pick OnSelect. Notice the formula: Navigate(WODDetails,ScreenTransition.Fade) Here is what … Continue reading PowerApps – Navigate between screens