Forum Discussion

AnandRanga's avatar
AnandRanga
Icon for Helper III rankHelper III
9 years ago

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...
Need Help
sdjensen's avatar
sdjensen
Icon for Solution Sage rankSolution Sage
9 years ago

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