If MS spends significant resources to port BI tools to Mac I'm not sure I'd be OK with that. There is so much that needs attention in Excel that MS has ignored.
"Take care of Windows users first" seems like a reasonable policy.
I'm typing this now on a Mac, so although I'd be pleased to have PQ on Mac Excel, support for VBA & macros are much more important to me on Mac environment. But since that's about as likely as Satya growing a goatee, I'll give this a vote.
If PQL, I'll pronounce it 'pickle'.
Need to be able to Google it. Disamguity needed.
Misspelled parameters. (This UI on Edge is wrapping text at every third word. Disorienting...just me? Weird.) I've been able to build a standard report in SF and then add params to the URL to narrow results. But cannot get these params added via Power Query. It looks like the API can pass params. The trick is to provide some way for us to add them to Power Query M statement. Without this workaround the limit of 2000 rows makes this feature almost useless because one never knows if results are complete.
Potentially, I could pull first 2000 rows sorted by ID, then pass ">LastID" and get the next 2000 rows. Or, just limit standard report to only one Account or Owner or Rep to ensure results are limited to small # of rows.Dory Owen shared this idea ·