Forum Discussion

Tuan's avatar
Tuan
Helper III
6 years ago
Solved

Shopify API - JSON Query Parsing

I'm a newbie at querying JSON APIs. I'm currently pulling Shopify api with read access. It comes into power query as a flat list. Is there a good way to break up all the Dimension and Facts tables or...
Need Help
  • mahoneypat's avatar
    mahoneypat
    6 years ago

    You should be able to do all of this in the query editor, and not need DAX tables.  Your approach to reference your initial query to make your other tables is a good practice, but there are some settings to consider when doing this.  This video has a good explanation of them, and their impact on the number of API calls made.

    https://www.youtube.com/watch?v=3uKNNZqBIkg

     

    If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

    Regards,

    Pat

v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi Tuan 

It is best to use power bi to connect to Shopify API and get tables (fact and dimension) directly.

If it can't be accomplished, you could create tables from a flat table using Power query or Dax which are suggested by mahoneypat and artemus.

Besides, i provide some links to do this:

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-calculated-tables

https://community.powerbi.com/t5/Desktop/create-table-from-existing-table/td-p/123553

https://ssbi-blog.de/blog/technical-topics-english/tables-in-power-query-how-when-and-why/

https://community.powerbi.com/t5/Desktop/Create-New-Table-and-Column-from-existing-Table-with-filters/td-p/493965

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.