Forum Discussion
getting data from SAP BW Query that has been changed in SAP BW Backend.
Thank you Ankit, but I did try that, but it did not add any of the new fields that were added within the SAP BW backend environment.
I can 'Get' data from SAP BW query (that has the new fields) and it does show all the new fields, but it is a new query in PowerBI at this point. So worst case; I would have to recreate the reports that are currently attached to the old SAP BW Query view, using the newly retrieved Query. But I was hoping not to have to go that route. Just wondering if this is unique to SAP BW connected Queries?
Cheers,
Lucy
Can someone tell me how to access the "Cube Tools / Manage" section of the Edit Queries section?
I have been able to see this; and it allows me to "Add Items" from an SAP BEx Query to the same BEx query that had been previously loaded to PowerBI.
Cheers,
Lucy
Dear Lucy,
You can go to "edit query" menu; and click on the "added items".
You can see here in the following screen shot:
You can add new items to PowerBI this way.
But the problem is, when you change the Bex query; (you add a new characteristic); PowerBI doesn't update the definition of the query :(
Since this was the first Google hit for my same question and the posts are very old, I'd like to add my findings. Under option - Data Load - Folders Artifacts Cache Options, clear cache. You will see any new measure added to your BW query definition when you go to add them to your PBI query.
Dear Lucy,
You can go to "edit query" menu; and click on the "added items".
You can see here in the following screen shot:
You can add new items to PowerBI this way.
But the problem is, when you change the Bex query; (you add a new characteristic); PowerBI doesn't update the definition of the query :(
