Allow Power Query results to be written back to a flat file or SQL table. Relivant forum thread: http://community.powerbi.com/t5/Integrations-with-Files-and/Can-PowerQuery-write-data-back-out/m-p/1...
i_feldmann
6 years agoNew Member
In order to avoid constant queries to the underlying datasources (like ERP-systems) for performance reasons, it would be great if one could save the results of the basic-cleanup steps in a csv-file which would then serve as the basis for all monthly reports. (“Lightweight DWH” without server, single point of truth)
Recent ideas
Enable OneLake to Read Snowflake-Managed Iceberg Tables via Horizon Catalog
1. Current Problem Snowflake lets customers create Iceberg tables where Snowflake manages both the catalog and the storage (CATALOG = 'SNOWFLAKE', EXTERNAL_VOLUME = 'SNOWFLAKE_MANAGED'). This is th...NareJoshi9 minutes agoMicrosoft EmployeeNew1View0likes0CommentsSet SQL analytics endpoint access mode (User's identity) via REST API and Terraform
The SQL analytics endpoint enforces OneLake security only in User's identity access mode. The only documented way to choose the mode is the Security tab in the portal (Data access mode settings). Not...smorimoto4 hours agoNew MemberNew2Views0likes0Comments