grcanosaalstom
2 days agoNew Member
Status:
New
PowerBI Delta Lake Connector without using Azure.DataLake
Current native connector to read delta lake tables in azure storage account using powerBI is to do this:
Source = AzureStorage.DataLake("https://STORAGE_ACCOUNT_NAME.dfs.core.windows.net/path/to/table/",[HierarchicalNavigation=true]),
Custom1 = DeltaLake.Table(Source),This present a very large overcost in terms of "List" operations in the storageaccount since the AzureStorage.DataLake needs to list ALL parquet files even if a lot of them may be inactive.
A better approach would be to only list hte metadata files and then read only the active files directly.
This way, using the delta-lake version, you could also avoid future reads if the version has not changed since last read.
I would like an improved PowerBI DeltaLake connector that actually uses PowerBI metadata.
No CommentsBe the first to comment
Recent ideas
extend storage capacity of varchar(8000) to varchar(max) for warehouse
The maximum string length of 8000 is often considered too short to store longer descriptive data or embed a JSON value within a text field in a database. Dividing the data into smaller chunks and st...c_mettler17 hours agoNew MemberCompleted3.3KViews61likes13CommentsAdjust column width in SQL Analytics Endpoint user interface
I can't see the column names and cell values in some of the columns in my tables in SQL Analytics Endpoint because the column width is too narrow. Also, the tooltip also doesn't show the entire...frithjof_v17 hours agoCommunity ChampionCompleted4.2KViews75likes8CommentsIn TableEX visual when using Custom tooltip, it shows below it the automatic "-> Drillthrough >"
Using in the Power Bi's Service Cloud. In TableEX visual when using Custom tooltip, it shows below it the automatic "-> Drillthrough >" and selects & clicks the drillthrough page. In TableEX vis...LR319 hours agoRegular VisitorNew4Views0likes0CommentsAllow Power BI subscription sender identity to be configured
The new Power BI subscription delivery platform changed existing subscriptions so that notification emails now show the subscription owner as the sender instead of mailto:[email protected]...bbussey21 hours agoRegular VisitorNew22Views4likes2CommentsSupport Workspaces folder pairing across Fabric Deployment Pipeline stages
Fabric Deployment Pipelines should support deploying items organized in workspace folders when equivalent folder structures exist across stages. Currently, deployments can be blocked when items are ...majofv22 hours agoNew MemberNew6Views0likes0Comments