Hi again, please supply me with your Skype ID so that I can add you from my side. It could be one of two issues; (1) Misconfiguration on your connection parametres, (2) The application is being blocked on the SAP BW Gateway. Do you have an on-site SAP BASIS team who maintains your SAP BW Environment? I can guide you through the technical stuff, but would prefer to do so on Skype due to the security risks involved with just posting all your server information on the net
One thing you can try in the meantime is to ask your SAP BASIS team to look into the parameters of the ACL on the SAP BW server. They can use transaction RZ11 to get to that. ACL = Access Control List. If your network is correctly set up and secured with Firewalls, etc.. then it should be safe to set the ACL so that it allows all. However this is done at your own risk. We are currently using our ACL like that and have never had any issues, however we have a large IT support environment and our network is extremely secure. Also ask the SAP BASIS team to look at the connection parameters you are entering on PowerBI to ensure the correct Instance Number, etc.. is being used.
I have fixed this. You need SAP.net connector installed in your GAC library. The SAP .net connector is available in SAP library. Once you start installing it will prompt for where to install, select the second option i.e. Install in GAC.
Also make sure you get the correct version of SAP. net connector. If you have 32 bit version of Power Bi desktop, you need 32 bit SAp.net connector else for 64 bit power Bi version, you need 64 bit >net connector.
Also I havent tried, but i believe these connectors will be available in GAC if you are in a windows 10 machine, so you can try that option too.