Forum Discussion

Atul0215's avatar
Atul0215
Frequent Visitor
1 year ago
Solved

How to Fetch 11M+ Rows from OData Entity in Power BI with Incremental Refresh?

I have a task where I need to fetch data from an OData entity with over 11 million rows and multiple columns into Power BI (either through Power BI Desktop or Fabric). However, I do not have SQL acce...
General Comment
  • Atul0215's avatar
    Atul0215
    1 year ago

    Hi Anonymous ,

    Since our database is very large, we plan to initially load all historical data up to the last 6 months. Going forward, we will enable incremental refresh to automatically load only new and updated data.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Atul0215 ,

May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.
Thank you for being a part of the Microsoft Fabric Community Forum!

  • Atul0215's avatar
    Atul0215
    Frequent Visitor
    1 year ago

    Hi Anonymous ,

    Since our database is very large, we plan to initially load all historical data up to the last 6 months. Going forward, we will enable incremental refresh to automatically load only new and updated data.

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi Atul0215 ,
      Thank you for updating!
      If our response addressed your query, please mark that answer as Accept as solution. It help others in the community to find it easily.

      Thank you for being a part of the Microsoft Fabric Community Forum!

      Regards,
      Pallavi.