Here is a common problem statement: I am using SAP BW Connector available in Power BI with import mode. When I either connect or refresh data, I get a MDX error and I need to make sense of it. How did I get the underlying MDX statement and debug through the issue… Here’s how. Create
Author: nikilprabhakar
I have been using Power BI BW connector to connect to composite provider and BEx query for a while now. I have run into issues where there is a memory overflow in SAP BW or time out error quiet often. This is typically due to the volume of data that needs to be retrieved. Here
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
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
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) reporting to them. This can be achieved using Roles in Power BI. In the previous post, we created
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 table. The employee table has a manager column that determines the hierarchy. E.g We want to flatten the
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,
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.
Once you create a PowerApp, you need the capability to share the app with users. How do we do that ? Let’s take a look. To share a PowerApp, the app has to be saved in the cloud. Local apps cannot be shared. If you are using PowerApps studio, click on File -> Share. This will
When a user navigates from screen 1 to the screen 2, we want to render content on screen 2 based on the user’s selection on the screen 1. To do this we have to pass the selected value(s) to screen 2. Let’s check out how to achieve this in PowerApps. Download the sample App from here. In the
