Forum Discussion
Power BI Desktop Odata data limit
I am trying to get data to PowerBI Desktop via an OData endpoint. We have eight OData endpoints with authentication and this works fine. But when the returned data volume is high from OData endpo...
Odata is not a sustainable option for Power BI reporting. If time is an issue and you want a one-off adhoc report that will only be used for a short period of time or if you want to review the tables and design a data model prior to exporting the data and denormalizing then Odata is a valid solution. When you are looking to build a future proof reporting solution that will scale with volumes and user demand then you need to look at exporting the data from the source application into a database or datalake and using views or flows to denormalize and ensure the model is more condusive for read and storage performance. OData is always a great short term solution but it shouldn't be considered anything else.