Forum Discussion

Kureigu's avatar
Kureigu
Frequent Visitor
2 years ago

Run For Each Entity in List in API Call (Sage200)

Hi,   I've been racking my brain with this issue for a while, my knowledge with Power Query is relatively limited, at least when it comes to M code - so apologies in advance for my poor terminology...
Need Help
lbendlin's avatar
lbendlin
Super User
2 years ago

There is no included connector "Sage200" in Power Query.  Is that a custom connector?

  • Kureigu's avatar
    Kureigu
    Frequent Visitor
    2 years ago

    Good question. There's a 'Sage 200Cloud' connector, which when using it appears to generate a query that's very similar to the 'Feed' query, but I've no idea how it's actually sourcing the information for that query as I've not provided anything personally and the data source is local/SQL (via API).

     

    The data source settings are below, whatever the 'Sage200' source is, it can't be exported.

    Edit: I've just noticed the 'Sage 200Cloud' source isn't available on my personal install of Power BI, so I guess that answers the question - it must be a custom connector that's integrated into the file somehow. No idea how to configure it though, or how it has been embedded.