A lot of my clients ask the following question: “Hey I am connecting to SAP HANA using import mode. I need to bring multiple years of data into Power BI for YoY analysis. This means millions of rows of data. When I try to refresh this dataset, it takes hours to complete and in most
Author: nikilprabhakar
As we know SAP HANA Connector is used to connect to SAP analytical and calc views. Sometimes HANA view might get complex and deep – it might have numerous joins, aggregations and the join might be between two fact tables (e.g. a join between Inventory and Sales tables). View might end up looking something like
As we know SAP HANA Connector can be used in both Direct Query and Import mode. When using Direct Query mode, we do get the option to create measures in Power BI. Not all DAX functions are supported. Aggregations like SUM, MIN, MAX, COUNT, DISTINCTCOUNT are the only ones supported. We need to be careful
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
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
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
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
