cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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. 

5 REPLIES 5
Super User IV
Super User IV

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. 


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

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Anonymous
Not applicable

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.

 

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

 

 

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. 


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

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Anonymous
Not applicable

ok, thanks for the help!

 

I will check the API document of Cin7

 

@Anonymous Hi, did you have any success with accessing Cin7 Data using API. I am also trying to achieve the same objective as you mentioned in this forum. Any help would be much appreciated. Thanks 

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session Drive Data Culture with Power BI: Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors