Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Hi,
ok, got it. Merging data is only possible for import data.
Is this the reason for the errors i get?
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.
Hi,
it works. This was the solution.
Thank you!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |