Getting Data from IBM TM1 (Cognos) by Get and Transform (Power Query) - Is it possible? RRS feed

  • Question

  • Hi all

    I am working with IBM TM1 reports and Views. 

    I am also working on a Data Model in excel, getting Data from different sources (SQL, Internal Portal, Excel Tables, Etc).

    A critical data source is a complex View I have on TM1. 

    I can export the view as *.cma (CSV) but I would rather connect to it as a Data Source (like ODBC or DB) since then I know the data I am extracting is fresh and not just the latest cma extract.

    Does power query support TM1 as a Data Source?

    Thank you!


    Thursday, September 26, 2019 8:13 AM