on
RE:
He use OpenRowset in all our projects.Allow usImplement data Virtualization, and avoid Staging tablesGrant access to data that is in the LZ but not in the User SQL tables with Views_LZImportant to haveThe ALDS / OneLake must be under firewall ==> Private endpoint compatible (**)Use SAS or Acces Keys . . .., But compatible with AAD (User MI or System MI) (**)Most of the Cases we use Authentication SQL Storage: Delegation / ImpersonateIn some cases for audit purpolses we need use Pass-Through Authentication, thus the AAD SQL user will appear on ADLS logsThe T-SQL Openrowset must be able to compile on Azure Data studio & Azure DevOps, currently is not able to do it and block all CI/CD progress (**)Format files (FMT) are really obsolete, need maintenance and are not part of Database Project / GIT, need to find a 2024 replacement (**)We hope that Select disctinct (col_1) [for Dim Tables] On parquet will be faster than on CSV, but sometimes is not (**)This Synapse "sugar" is very appreciatee: '*/*/*/myfile*.parquet'Currently select from openrowset INTO #Temptable is not supported (**)All the others: AGG pushdown, Metadata, Vertipaq / V-Order, PurView , , . . . future??(**) Hugo Queiroz knows about these issues and some of them are ACK by Azure support
RE:
Exactly. Something like “Number LP in order of Put sequence” Would need to put some explanation that “standard sequencing assigns newly put LP as 1 and increments all current LP numbers by 1. Selecting “Yes” will assign each new license plate with an increment 1 greater than the previous LP.”
RE:
This is a great suggestion! We recently encountered the same issue. On our main form the currency field is populated correctly as " kr 16 427,25", while in an email it is populated as "kr 16427.25". This can be confusing and easily misread.
RE:
7 years on from the start of this idea (read NECESSITY). And still totally ignored by MS. The only conclusion that you can draw is that either MS don't actually use Power BI themselves, or that they've never come up with a column heading longer than 10 characters.Table and matrix visualisations are long overdue a huge overhaul.
RE:
Please provide a more recent update on this topic.
RE:
One of the last functionalities which can not be handled trough the WMS features and hence can not be put and picked using a scanner in the warehouse. When can we expect this feature?
RE:
a must...why still pending?
RE:
We would highly appreciate this function also for Sales Credit Memos (not only Sales Invoices) - Mistakes happen on both sides!
RE:
Much awaited since it is blocking our business scenario.
RE:
13 comment pages.....4 years...over 1000 votes....come on, give us some news on this topic🙌