Good evening everyone,
I’m an intern in my first month of experience in the IT field, with the role of Junior Business Intelligence Technician. I’m gradually getting involved in the team’s projects and trying to orient myself as best as possible.
Recently, I was assigned the task of analyzing how to manage an integration between Shopify and Power BI, and while researching, I initially considered GraphQL as a possible solution. However, after gaining access to the store and trying to retrieve all products, I discovered there’s a limit of 250 items per call, which complicates things a bit given the volume of data expected in the project.
At this point, I’m evaluating alternatives, including:
-
using REST API or GraphQL through a Python script to overcome the limit
-
using an intermediate database to connect to Power BI
-
or adopting ready-made external connectors
I would really appreciate advice from those who have more experience and expertise than me in this field. If I’ve overlooked something or haven’t explained myself well, I’m very open to corrections!
Thanks so much in advance to anyone who wants to dedicate a few minutes to me. And of course, I’m happy to offer virtual coffee!