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.
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.
Proud to be a Super User!
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.
Proud to be a Super User!
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
Featured Session Drive Data Culture with Power BI: Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
User | Count |
---|---|
437 | |
186 | |
109 | |
59 | |
50 |
User | Count |
---|---|
439 | |
187 | |
122 | |
74 | |
72 |