Power BI SAP BW Connector – Enable Tracing

No comments

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 an environment variable, PBI_EnableSapBwTracing and set it to true.

BWLogging1

Open Power BI Desktop file and navigate to File -> Options and Settings -> Options  -> Diagnostics.

Select Open crash dump/traces folder.

BWLogging2.jpg

This opens the trace folder.

Now refresh the report or create a new query.

Notice trace files are created with the MDX query. Open this file and copy the MDX statement.

BWLogging3

Open SAP GUI and use tcode MDXTEST.

Paste the MDX statement and execute it. You will get more details and work through the issue.

BWLogging4

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s