Importing data from Navision is very slow

[JarnoVisser]

Hi all,

I have a customer where we use Navision as a data source. The database is on premise and we use an Odata feed to get the data from navision. We have a data model which contains one big table (aprox. 10 million rows) other tables are small.

The problem is that importing the data takes 5 or 6 hours when importing it in Power BI Desktop. When I schedule a refresh in Power BI Online it stops after 2 hours because it takes too much time. 

We have other customers using the same way but there it's lots faster (aprox. 15 - 30 minutes). 

Is there anyone who encountered the same problem? Any ideas how to solve it?

Thanks in advance!

Kind regards,

Jarno Visser

[v-yalanwu-msft]

Hi， @JarnoVisser ；

When the refresh is in fact slow, it can be due to several reasons:

• Insufficient CPU (refresh can be very CPU-intensive).
• Insufficient memory, resulting in refresh pausing (which requires the refresh to start over when conditions are favorable to recommence).
• Non-capacity reasons, including datasource system responsiveness, network latency, invalid permissions or gateway throughput.
• Data volume - a good reason to configure incremental refresh, as discussed below.

2.Optimizing models
Optimal model design is crucial to delivering an efficient and scalable solution. However, it's beyond the scope of this article to provide a complete discussion. Instead, this section will provide key areas for consideration when optimizing models.

https://blog.pragmaticworks.com/power-bi-performance-tips-and-techniques

3.In addition,can also purchase premium capacity  .

https://apollogic.com/2021/04/power-bi-premium-generation-2/

4.Use Dataflow to Make the Refresh of Power BI Solution FASTER.

https://radacad.com/how-to-use-dataflow-to-make-the-refresh-of-power-bi-solution-faster

Best Regards,
Community Support Team_ Yalan Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.