SAP BW Dataflow Connector

Yes, same issue with my dataflows.  I too ran into the memory error message when refreshing my PBIs and was going down this path for the exact same reason.  So I decided to build separate dataflow for each year of my sales data. My problems started with not being able to edit the data flow.

I noticed that if I tried to edit the dataflow and then add a field from BW, I would not get the gear next to the step name so I could not pull up the data source and select a new field or change existing ones.  And if I right clicked the step name the "Edit Settings" would be grey.  But the data would pull for the preview.

As I had already built the one for 2021, I used the export JSON feature to export that one, import it as a new dataflow and rename it. Then I would open the advanced editor and manually edit the month/year selections for the year I needed.  This worked until this week when it suddenly wouldn't pull the preview data and then wouldn't let me save it since it detected an error.  I had already built 2019-2021 but this week discovered I needed 2018 and 2017 as well.

I was lucky the only thing I had to change was the year number for the filter and the various name references.  To work around the editing issue I exported the JSON file for 2021, opened it in a text editor, replaced "2021" with "2017" and saved it as a new JSON file.  Then I imported that as a new dataflow and was able to refresh with no problems.

I did notice the problem of getting the "DataSource.MissingClientLibrary" error only happens when I try to edit an existing dataflow.  I've been able to create a new one from scratch with no problems.  The data preview works okay and I can save it.  I can also refresh existing dataflows with no problem.  If you were desperate enough I guess you could export a JSON file for one you wanted to change and then manually edit it and re-import it to make any changes but that would be a fair amount of work as well.

So I guess that could be a workaround but definitely look forward to having them fix the real issue.