Solved

How to link AIMMS with PowerBI

  • 4 September 2020
  • 2 replies
  • 44 views

Hi,

I would like to know if is possible to create a direct link from AIMMS to PowerBI and if not, if is it being planned?

icon

Best answer by Gertjan 4 September 2020, 16:15

Hi @Gustavo Mendes ,

 

There will be no specific AIMMS build link to PowerBI available. We indeed have this for Tableau and recently deprecated it as we moved to more general connectivity (assume your ask is about getting something alike).

Also, PowerBI does not, as Tableau, have a native data exchange file (TDE in Tableau). So their request is to just use the standards available: push data to databases, or to common data files such as CSV, XLS, JSON etc. Seeing similar request for other BI tools, we started to promote the use of general data exchange interfaces so you are flexible to use any BI tool and can also change easily (be independent of the specific BI tool). 

 

AIMMS provides all these options so you can push data centrally, or generate data exchange files for pick up by BI tools such as PowerBI, Tableau, Qlik, TIBCO Spotfire etc. This makes you independent of use having to develop and maintain all the individual interfaces of all the BI tools that might exist. 

 

I suggest you look at our new Data Exchange Library as that will likely give you all you need (or you can opt for database exchange of course):
     https://documentation.aimms.com/dataexchange/index.html

 

View original

2 replies

Userlevel 6

Hi @Gustavo Mendes ,

 

There will be no specific AIMMS build link to PowerBI available. We indeed have this for Tableau and recently deprecated it as we moved to more general connectivity (assume your ask is about getting something alike).

Also, PowerBI does not, as Tableau, have a native data exchange file (TDE in Tableau). So their request is to just use the standards available: push data to databases, or to common data files such as CSV, XLS, JSON etc. Seeing similar request for other BI tools, we started to promote the use of general data exchange interfaces so you are flexible to use any BI tool and can also change easily (be independent of the specific BI tool). 

 

AIMMS provides all these options so you can push data centrally, or generate data exchange files for pick up by BI tools such as PowerBI, Tableau, Qlik, TIBCO Spotfire etc. This makes you independent of use having to develop and maintain all the individual interfaces of all the BI tools that might exist. 

 

I suggest you look at our new Data Exchange Library as that will likely give you all you need (or you can opt for database exchange of course):
     https://documentation.aimms.com/dataexchange/index.html

 

Thanks @Gertjan.

Reply


Didn't find what you were looking for? Try searching on our documentation pages:

AIMMS Developer & PRO | AIMMS How-To | AIMMS SC Navigator