Forum Discussion
Connect to Apptio from Power BI
- Anonymous2 years ago
Hi,Venkat_Thota . I am glad to help you.
Hello,rajendraongole1,thanks for your concern about this issue.Your answer is excellent!
Unfortunately ,I can't find anything at the moment about a connector for power BI to connect to Apptio.
As rajendraongole1 suggests, using RestAPI for data fetching is a very good solutionHere I would like to share some additional solutions below.
If you need to make a good report to publish to a service and do a refresh operation
I suggest you to use RestAPI+dataflow method.
Create a dataflow, and configure the API data source, then publish the dataflow to the service, you can use the created dataflow as a processed data source。 And for the report data refresh, you can configure the dataflow refresh schedule to achieve. By combining them, you can avoid the situation that the report made by the data source obtained from API cannot realize the gateway connection on the service directly.
URL:
Power BI REST APIs for embedded analytics and automation - Power BI REST API | Microsoft Learn
Creating a dataflow - Power BI | Microsoft LearnI hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,Venkat_Thota . I am glad to help you.
Hello,rajendraongole1,thanks for your concern about this issue.
Your answer is excellent!
Unfortunately ,I can't find anything at the moment about a connector for power BI to connect to Apptio.
As rajendraongole1 suggests, using RestAPI for data fetching is a very good solution
Here I would like to share some additional solutions below.
If you need to make a good report to publish to a service and do a refresh operation
I suggest you to use RestAPI+dataflow method.
Create a dataflow, and configure the API data source, then publish the dataflow to the service, you can use the created dataflow as a processed data source。 And for the report data refresh, you can configure the dataflow refresh schedule to achieve. By combining them, you can avoid the situation that the report made by the data source obtained from API cannot realize the gateway connection on the service directly.
URL:
Power BI REST APIs for embedded analytics and automation - Power BI REST API | Microsoft Learn
Creating a dataflow - Power BI | Microsoft Learn
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,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous ....okay it make sense. thank you.