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
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. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        ok, thanks for the help!

         

        I will check the API document of Cin7