Forum Discussion

michellmadeira's avatar
michellmadeira
Frequent Visitor
5 years ago

Datasource with too many applied steps not refreshing

Hi,    I have this data source with too many applied steps, and can't refresh with my gateway cluster on PowerBI online service (below). Clicking it has no effect anymore:      Here you c...
Dataflow
Need Help
michellmadeira's avatar
michellmadeira
Frequent Visitor
5 years ago

 

 

As you see, I've already tried a function with Table.AddColumn for each IDs I have.

 

So you suggest calling a function that compiles all the information before rendering it in the data source?

 

I will try this.

 

GilbertQ's avatar
GilbertQ
Super User
5 years ago

Yes I would try that it might work well.

  • michellmadeira's avatar
    michellmadeira
    Frequent Visitor
    5 years ago

    I've tried the following:

     

    a) M Table.Combine with 1 function call, having 100 API calls combined, it worked

     

    b) M Table.Combine with 10 function calls, having 50 API calls combined each, didn't work

     

    c) My last try is to have M Table.Combine with 1 function call, having 500 API calls combined

     

    My goal is to have 1.000 API calls compiled as a table.

     

    Otherwise, I will change my strategy to have an Excel file on sharepoint with this table.

    Edit: I've noticed that when it doesn't work, it also breaks the Gateway Cluster, demanding it to be reset.

    Edit2: no chance, it just can't work: