Post by @paul
Helping a client with a PowerBI data connection today.
They were trying to use an API that didn't allow connectivity to a table unless you provide an ID parameter. I wasn't overly clear myself so I read a little documentation about it. When coming back to them, they had asked ChattyPeePoos how to do it, and it had given them back some BEx which it confidently said would do it.
It wouldn't, at least not providing some more context.
But, the person quite happily copy and pasted the code, replacing the code PowerBI already had (you know, the stuff that defines the datasource a few navigation steps to provide the table view) and, lo and behold... Fail. And because it's PowerBI/Query no going back.
I talk them through how to do it via the documentation, and done.
Tell me again how this shite is here to stay.