IBM TM1 connection to PBI by Direct query

[Yogi_TN]

I want to connect IBM TM1 to Power BI by direct query mode, I can connect TM1 using the TM1py library in Python but it's in import mode only I want to connect TM1 by direct query mode into Power BI. I Don't want to store data inside Power BI or any other middle layers. Please give me any workaround solution for this.

[Anonymous]

Hi,rajendraongole1 ,thanks for your concern about this issue.

Your answer is excellent!
And I would like to share some additional solutions below.
Hello,@Yogi_TN .I am glad to help you.

Has your problem been solved?

If you have found suitable solutions, please share them as it will help more users with similar problems.
Or you can mark the valid suggestions provided by other users as solutions.
Thank you very much for your understanding and support of Power BI.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian

[rajendraongole1]

Hi @Yogi_TN - Can you check the below reference links and solved threads:

Connection to IBM Cognos TM1 via OData - Microsoft Fabric Community

How to connect TM1 cube to Power BI by using Rest ... - Microsoft Fabric Community

DirectQuery your custom REST API in Power BI (progress.com)

Connection to IBM Cognos TM1 via OData - Microsoft Fabric Community

Getting TM1 data into Power BI (cubewise.com)

Note: Power BI does not natively support DirectQuery for IBM TM1 (also known as IBM Planning Analytics).

Hope this helps