Forum Discussion

FrankieMcQ's avatar
FrankieMcQ
Frequent Visitor
7 years ago

Single JSON call feeding multiple queries

Hi I am using a JSON query to retrieve data. The data is nested with tables within tables to such a degree that it is simpler for me to select only the tables I'm interested in and remove the rest. I'm ending up with about a dozen different queries based on the same JSON root with the accompanying performance issues. Is there anyway I can set the JSON query up once and then supply to multiple queries? Many thanks
Need Help

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    7 years ago

    Hi FrankieMcQ,

     

    You were attempting to set up a single JOSN call which contians different source tables to generate and load multiple queries (datasets) into Power BI desktop, right? I'm afraid this is not supported by now. If you want to fetch different data tables from data source, you have to manually load the JSON query fo multiple times and apply different transformations to each query. 

     

    Best regards,

    Yuliana Gu