Merge SAP BW Query (Direct Query ) with Excel

[Sevhan]

Hello everyone,

i `m trying to merge a SAP BW Query with a Excel File.

I have a few questions. Hope someone can help me.

1) Is it possible to merge a SAP BW Query with Excel files? If yes, is it also possible if the SAP BW Query runs in mode "Direct Query"? 

2) Do I need need the Gataway also in the Power BI Desktop Version? Or is it only necessary for the Cloud Version?

Below are stepts, i have done to merge a SAP BW Query in Direct Query mode with an Excel File. In the last step, trying to close and apply, i get the error message below.

1) Click get Data and selelct an excel file.

2) click on "transofrm data"

3) Add the new Source SAP BW Query (Direct Query)

4) Selectm mode DirectQuery

5 Select Merge Query

6) Do the Merge with Key "Year"

7) Merge is successfull 

😎 Go to Close&Apply

I get following warnings:

Thank you in advance

Sevhan

[mussaenda · Accepted solution]

Hi @Sevhan ,

first, merging a direct query and a local file will change the query to import mode.

Direct Query restricts many functions in Power Query and some in DAX.

To understand which query you must use that is best fo your needs, I am leaving you this thread.

Thank you

[Sevhan]

Hi, 

ok, got it. Merging data is only possible for import data.

Is this the reason for the errors i get? 

[mussaenda]

We can answer that if you will apply it first to your report and see if the error will still occur. 

If yes, then it is not the only reason.

Do not forget to back up your file, just in case.

[Sevhan]

Hi,

it works. This was the solution.

Thank you!