Forum Discussion
michellmadeira
5 years agoFrequent Visitor
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...
GilbertQ
5 years agoSuper User
Yes I would try that it might work well.
michellmadeira
5 years agoFrequent Visitor
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: