Connecting Power BI to Factory Talk Metrics (FTM)

[DanielG69]

Hello and thank you for hosting this site to allow for questions, I have been readin and if something comes up that one of you experts haven't already answered, if I know I will do my best to contribute in that way.

We have a large manufacturing company multi site and they have several types of systems in place now for data collection, input, output, metrics, etc. Rockwell came in and bought the company they were working with, and now we are struggling to get off the ground. 

As a result we have begun lookin at alternative applicatioons and measures, with Power BI. Our current issues has to do with connectivity, and how to link/connect/associate the two FTM and Power BI. I am searching the forums using the keywords, but not really seeing something specific to my question, but that could be my newbieness. 🙂


Thank you for reading, and I hope to be a contributor once I am more gooder at this.. 

Daniel 

[v-chenwuz-msft · Accepted solution]

Hi @DanielG69 ,

I had no found Factory talk metrics in power bi datasource.

https://docs.microsoft.com/en-us/power-bi/connect-data/power-bi-data-sources

So, please connect the Factory talk metrics to get help or if you have api of the Factory talk metrics, you can use Web.Contents.

Or you export the data from FTM and get data from the xml or csv files.

https://literature.rockwellautomation.com/idc/groups/literature/documents/gr/ftldb-gr001_-en-e.pdf

Best Regards

Community Support Team _ chenwu zhu

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