Skip to main content

    Power BI

    Under Review

    Add shopify data

    Vote (115) Share
    Neil Vaidya's profile image

    Neil Vaidya on 28 Jan 2015 02:42:27

    Administrator on 28 Jan 2015 06:11:51

    Thanks Neil! Shopify is a really interesting data source! Is anyone else out there using it? Please add your votes if you think we should prioritize this!

    Comments (23)
    Neil Vaidya's profile image Profile Picture

    719e63ba 044f-415c-b04e-82b366ddd8a5 on 06 Jul 2020 00:14:31

    RE: Add shopify data

    Hello! I'm new to Power BI and have a shopify site I'm pulling data from. I've used Matt Jackman's method successfully below but am only able to pull in 50 lines of data (or 250 if I set limit). I'm struggling to understand how to make multiple calls to the shopify site with Power BI query editor to pull all data, not just 50 lines. I know there is a limit, and have read multiple articles but it's above my head. Can someone please provide query code (or link to clear instructions) on how to pull all data, not just 50 lines? thanks!!

    Neil Vaidya's profile image Profile Picture

    6532e7ce 90da-433b-9182-1add8ef47aaf on 05 Jul 2020 23:51:35

    RE: Add shopify data

    Shopify is very popular！

    Neil Vaidya's profile image Profile Picture

    c5d78a02 fe63-45d3-9a7f-19fc0108828a on 05 Jul 2020 23:38:55

    RE: Add shopify data

    Please make this happen ASAP.

    Neil Vaidya's profile image Profile Picture

    7edcd039 971f-4938-8de5-b7b55ee5c5bb on 05 Jul 2020 23:33:25

    RE: Add shopify data

    Sounds like Matt Jackman has a great workaround!

    But if anyone else needs more than that and his suggestion does not meet your needs, feel free to send me an email. I'd like your advice on what you need from Shopify to Power BI so that I don't build the wrong thing.

    Cheers!

    Neil Vaidya's profile image Profile Picture

    7d5e7ab3 c0ff-e811-a95c-000d3a4f33c1 on 05 Jul 2020 23:32:51

    RE: Add shopify data

    What Matt Jackman wrote below works a treat, thanks for that tip!!!

    Neil Vaidya's profile image Profile Picture

    000eedb4 046f-4f5f-82a4-7141efacba2d on 05 Jul 2020 23:10:41

    RE: Add shopify data

    I would love it if there was a native shopify connector

    Neil Vaidya's profile image Profile Picture

    376d7f3d a819-4de5-9c59-9bcb105f074e on 05 Jul 2020 23:09:19

    RE: Add shopify data

    To Matt Jackman - Thanks for sharing your notes. Can you share some more about how you're using the data? Do you have a bog?

    Neil Vaidya's profile image Profile Picture

    fdc50f5e 9344-45b6-a6f3-575efa7fa236 on 05 Jul 2020 23:08:30

    RE: Add shopify data

    Absolutely please add this. Would be high value to all Shopify stores.

    Neil Vaidya's profile image Profile Picture

    ac05ee1c b9f0-43e3-8519-e4521713f709 on 05 Jul 2020 23:06:36

    RE: Add shopify data

    Are we any closer to this? I already pay for access to Power BI and currently the apps available are another paid source. with 18 shopify stores i need data from this is not ideal

    Neil Vaidya's profile image Profile Picture

    7538f13d 6faa-4b3c-82f7-02d7afb3e6da on 05 Jul 2020 23:05:28

    RE: Add shopify data

    Please add this capability... many companies use Shopify, and the ability to pull that data into Power BI would be tremendous.