opkwashington.blogg.se - Power query mac excel 2019

But frankly, I even forgot how to write VBA. Question from me: Can Microsoft provide an update on this? Where do you stand now.In September 2014, I wrote a blog post on dynamically passing parameters from PowerPivot to a SQL Server stored procedure using VBA. As you can understand, this is an expensive project and we adopted a staged delivery plan - we aim to release valuable functionality to the users as soon as we are done with coding and testing"

Also providing feedback saying that "the goal is to support full query authoring on Mac. See below couple of things I was able to find on Hunkin, Program Manager at Microsoft writes an article in October 2019 about the introduction of the ability of refreshing existing queries in Excel for MacOS.

Any workarounds available to avoid having to have a Windows OS to be needed?.

Can Microsoft provide transparancy regarding their roadmap? What can we expect by when - and what not?.

Hoping I can get more details on things such as: Seeing as this was stated somewhere in 2019 it does make me curious to understand where Microsoft stands now in regards to further rolling out this functionality for MacOS.

Looking at the amount of users voted for getting this feature fully supported on MacOS I am confident this is something that is continuously being worked on by Microsoft. Spending a week on researching the internet learned this functionality is not - yet - available for MacOS.įrom what I have been able to learn, the newest Excel 365 does offer the option to refresh existing queries - queries created on a Windows machine, though also learned according to Microsoft this is rather "phase 1" and we should expect more to come. More or less immediately ran into issues when trying to find the Get & Transform functionality on the MacOS - it simply was not there. Recently switched over from Windows to MacOS, not knowing the versions of Excel 365 for both the OSes are not the same.