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 … Continue reading Power BI SAP BW Connector – Enable Tracing
Category: Power BI
How to overcome SAP BW memory overflow issue
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 … Continue reading How to overcome SAP BW memory overflow issue
Scheduling Power BI Data Refresh using APIs
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 … Continue reading Scheduling Power BI Data Refresh using APIs
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
Content Packs vs Power BI App
Sometimes, in order to innovate, we have to take a step back before we take two steps forward. What that statement means in the context of this article is a mystery and for many of us such is the difference between Content Packs and Power BI Apps. Microsoft revealed Power BI Apps in this blog … Continue reading Content Packs vs Power BI App
Power BI and Azure Data Lake
Do you have to be a developer in order to implement a solution that ties together Power BI and Azure Data Lake? I argue that you don't. However, there are a several things that you need to be familiar with before you get going. Therefore, I decided to cover several of them in this article. … Continue reading Power BI and Azure Data Lake
Embedding PowerApps in Power BI Dashboards
It's no secret that PowerApps and Power BI are related or so you might think considering that both products have the word "power" in their names. Although Microsoft is yet to officially introduce the big picture of how Power BI, Power Apps and Flow will come together, having a shared gateway infrastructure between the three … Continue reading Embedding PowerApps in Power BI Dashboards
Power BI and SAP – What Works and What Doesn’t
I run many workshops focused on integration of Microsoft Analytics and SAP. This is not an easy topic to cover due to complexities of the SAP landscape and also because Microsoft Analytics has many moving parts both with respect to its on premise and cloud components. In this article, I will just focus on Power … Continue reading Power BI and SAP – What Works and What Doesn’t
business intelligist 