Hello,
we have a cloud solution where data is available through a Rest Api.
We tried to develop a custom connector for this, and it worked well from within Power BI Desktop. But it fell short on the limit that custom connectors cannot be set up for automatic refresh in Power BI services. And we'd rather not need to use a Gateway, as we have several different customers in our cloud solution - and we'd need one Gateway for each if I understand it correctly.
So I wonder: what would be the best way to set up a connection to create reports from this Api, that would support automatic refresh?
We would ideally like our tables to be selectable in full after the connection is made (i.e. we don't want one connection per table).
Do we need to support full OAuth for this?
Could using the OData connector help?
Thanks for any response.
