I have PowerBI Connected to = SapBusinessWarehouse.Cubes("XXX.XXX.XXX.XX", "YY", "ZZZ", [Implementation="2.0"]) PowerBI Desktop connected and pulls the data in import mode. This works perfectly well...
Thanks for checking. There are not any other issues with credentials etc. If I start building the dashbaord for 2nd SAP system it works. The requirement is that we have taken months to build one dashbaord which works on one SAP system and now we want use it for another SAP system. By changing the data source to another SAP system it should work.