Posts Tagged ‘Excel Power Query’
Using Popdock with Power Query
There are many times when building that perfect Excel or Power BI report has more complex data requirements than Power Query can handle effectively. That’s where Popdock comes in!In this video, we will show you how easy it can be to pull data from wherever it is, easily and efficiently, and then feed that data…
[Read More]Tech Thursday : Query a Dynamics NAV Page using Excel Power Query
When creating a map sending data into Microsoft Dynamics NAV from Excel, it is often useful to be able to query existing NAV pages for lookups or populating data validation dropdowns in Excel. Fortunately, Excel Power Queries make it very easy to see the contents of a NAV page! To create the query, all we…
[Read More]