Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Get the data from Cin7

I have to connect the Cin7 inventory tool to power BI.

 

Please let me know any option in power BI to connect the CIn7 tool. 

Need Help

8 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    9 years ago

    Their website and documentation is fairly unhelpful. What you would be looking for is some type of RESTful web services interface for getting access to your data in either a web page, JSON, XML or other common data format. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      I want the connection like Excel or SQL. 

       

      So when I refresh the data new data is updated and my dashboard is also updated. 

       

      I can connect to the power BI services. 

       

      I want to create a visualisation of the inventory data of Cin7.

       

      -------------------------------------------------------------

       

       

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        9 years ago

        There is no content pack (app) for Cin7. And the Service itself only supports Excel and SQL. Your best option is to download Power BI Desktop and use the web connector, JSON connector, XML connector, OData connector, etc. If Cin7 has a RESTful web service that supports this then you could use Desktop to build your reports, publish the PBIX file to the Power BI Service and then, as long as the source is some sort of RESTful web service then the "cloud gateway" in the Power BI Service should support automatically refreshing data on a scheduled basis.