I actually got 3 different servers, SRVAPP1, SRVAPP2 and SRVFILES, I can reach data from both SRVAPP1 and SRVAPP2. Yes, I tried it and if I'm not wrong ODBC isn't working anymore and OLE DB is only available in 32 bit version (I installed it and I could see it on PBI 32 bit but not in PBI 64 bit). I hope that someone can help me and that everybody understood my problem, English isn't my first language, I did my best to explain this. I saw that there is a lot of drivers like Advantage Database from iAnywhere or Devart ODBC Driver but none of them work for me, maybe I do something wrong. I'm searching for a solution since 2-3 weeks and I didn't find any, the only good advice I found is to check if the ports are open, but I've no idea of which ports.
I tried to read my data by intalling Power BI Desktop on the server and it worked, so I don't think that I have a connection problem between my computer and the server. I installed my driver on my server ( exactly like I did for all the others drivers I use) and when I try to create the data source for the gateway I have an error.
Then I found the ".12.0" Driver, which works, I can read my data in Power BI, but I can't properly use the data gateway and I need it. Firstly I tried using the basic ODBC and OLE DB Drivers, but they are both in 32 bit and I need to work with the 64 bit version of Power BI. I need to access a Visual FoxPro database in Power BI. I'm new in the Power Bi universe, I'm working with this software since 2 months, so I don't have a lot of experience.
0 kommentar(er)
