Error using ODBC connection to UNIT4

[JarnoVisser]

Hi,

We have a lot of trouble trying to connect Power BI to UNIT 4 Multivers Online. I'm using the 32 bits ODBC driver to connect. 

This is working fine because i am able to connect to the database and can see al the tables. But when i select a table and try to import in Power BI i get the following error:

Even UNIT 4 itself has no solution... Is there anyone which has experience with this?

Kind regards,

Jarno

[karaoan]

We specialise in integrations for ERP systems that synchronize all data in a cloud based or on premise based MS SQL Server data warehouse (star schema) model optimized for analysis in Power BI + Power BI best practice templates: https://www.acterys.com  At the moment a Unit4 / Venice Connector is under development. In the meantime you could use the generic integration option in the solution. 

[Icey · Accepted solution]

Hi @JarnoVisser ,

Is this problem sloved?

If it is sloved, could you kindly accept it as a solution to close this case?  

If not, please let me know.  

Best Regards

Icey

[Icey]

Hi @JarnoVisser ,

Can you preview your data tables? If can't, please refer to this post: ODBC DataSource.Error when expanding a table.

Best Regards,
Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.