Forum Discussion
Using On-Prem Data Gateway for OData Feed
Community SupportHi Isimon
You need to know, gateway is use to connect clodu service and on-prem datasource. You could refer to What is an on-premises data gateway? for details.
In addition, you need to know, the data limit for import and direct query. You could refer to this post and Power BI Tips: Import vs Direct Query for details.
By the way, you also need to check whether there is something wrong in one dataset which will casuse the next dataset can't be processed.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi dax,
How would we go about changing from an OData feed to SQL server + our on-premise gateway + DirectQuery in Power BI/Power BI Service?
- dax
Hi lsimon,
Did you mean that you want to import OData feed data into sql server , then use SQL server as datasource and add gateway, right? If so, you could refer to How to import data into SQL Server databases using the OData source for SQL Server Integration Services for details.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.