RE:
Power BI definitely needs a scripting language to really get work done. Any language Javascript or VBA - anything. Recorder like Excel.
RE:
This is really bad. It means every NestedJoin (which is default join from UX) messes up your column types on expansion. Every single one. Same issue when adding Index via GroupBy/ExpandTableColumn.And these errors are very hard to track down. Table.Combine can just hang spinning trying to reconcile two tables where in one a column is text and in another it's Any.So bad this is, I had to write a helper function to reapply column types based on previous types. Should be handled by the language itself.
RE:
Being able to downgrade trial SKU would be a great tool for doing a POC (proof-of-concept).
RE:
What about the "Stockkeeping Unit Exists" field on the Planning Tab? That's the one I use when I need to know if there might be any SKU impacting my planning parameters.