Auto-Updating an Excel file from Dynamics NAV using PowerQuery

(0) Share

Report

Posted on by WorkingRicardo

749

I thought an Excel file I was counting on being updated would be but had to manually update it. As of now, it grabbed its data from a month old update it did from NAV when we created the file. I set up the option in DATA ->UPDATE EVERYTHING - > UPDATE EVERY x minutes. I have set this to even 5 minutes and no luck.

Does it have to do something with credentials? I don't have a NAV account here, but my boss does, and I was the one who told him to set up the Excel file like that.

Either way, i need this file to constantly be pulling info from the NAV to see if there's something new to add. Is there no way?