Forum Discussion
Fetching data using data feed from NAV 2016 and setup a refresh schedule ?
I need to create a dashboard in Power BI from NAV data. In that I need to fetch the data from NAV web service and need to update the dashboard on daily basis. The data is huge actually, So my queries are that :
1) Is power BI is right solution for huge data as I read somewhere that it is not able to handle huge data.
2) Is there incremental load in power BI, so that when I will schedule a refresh it should refresh only data that is not available in power BI? Can I use incremental load type thing in power BI using some alternate way ?
3 Replies
There are 3 content packs for NAV in Power BI. You can import up to 10GB of data into Power BI and you also have some Direct Query options for really huge datesets. There is no incremental load in Power BI yet.
AnandRanga - Hi, I work as a BI Consultant at a NAV vendor and we build our own Power BI models on top of NAV data. I would always use the SQL Database as the source for the models instead of using the Web Service (I take it that you mean OData when you refer to the Web Service) because fetching data through OData can be very slow.
You say that you have huge data - what is huge data to you? How many rows are in the biggest table that you need to add to your model?
If you are interested you can see one of the models we build on top of a NAV demo database here: (The model is developed in Danish) NORRIQ Power BI Accelerator - Sales
Hi AnandRanga,
Adding to others’ post, some ideas about incremental load and incremental refresh have been submitted in the following links, please vote them up.
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/7288623-incremental-data-loads
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/14594856-add-incremental-updates-to-enterprise-gateway
Thanks,
Lydia Zhang
