PBI Hub文档
说明
Access.Database
ActiveDirectory.Domains
AdoDotNet.DataSource
AdoDotNet.Query
AdobeAnalytics.Cubes
AmazonRedshift.Database
AnalysisServices.Database
AnalysisServices.Databases
ApacheSpark.Tables
AzureEnterprise.Contents
AzureEnterprise.Tables
AzureHiveLLAP.Database
AzureSpark.Tables
AzureStorage.BlobContents
AzureStorage.Blobs
AzureStorage.DataLakeContents
AzureStorage.Tables
Binary.Buffer
Binary.Combine
Binary.Compress
Binary.Decompress
Binary.From
Binary.FromList
Binary.FromText
Binary.InferContentType
Binary.Length
Binary.ToList
Binary.ToText
BinaryEncoding.Base64
BinaryEncoding.Hex
BinaryFormat.7BitEncodedSignedInteger
BinaryFormat.7BitEncodedUnsignedInteger
BinaryFormat.Binary
BinaryFormat.Byte
BinaryFormat.ByteOrder
BinaryFormat.Choice
BinaryFormat.Decimal
BinaryFormat.Double
BinaryFormat.Group
BinaryFormat.Length
BinaryFormat.List
BinaryFormat.Null
BinaryFormat.Record
BinaryFormat.SignedInteger16
BinaryFormat.SignedInteger32
BinaryFormat.SignedInteger64
BinaryFormat.Single
BinaryFormat.Text
BinaryFormat.Transform
BinaryFormat.UnsignedInteger16
BinaryFormat.UnsignedInteger32
BinaryFormat.UnsignedInteger64
BinaryOccurrence.Optional
BinaryOccurrence.Repeating
BinaryOccurrence.Required
Byte.From
ByteOrder.BigEndian
ByteOrder.LittleEndian
Cdm.MapToEntity
Cds.Contents
Character.FromNumber
Character.ToNumber
Combiner.CombineTextByDelimiter
Combiner.CombineTextByEachDelimiter
Combiner.CombineTextByLengths
Combiner.CombineTextByPositions
Combiner.CombineTextByRanges
Comparer.Equals
Comparer.FromCulture
Comparer.Ordinal
Comparer.OrdinalIgnoreCase
Compression.Deflate
Compression.GZip
Csv.Document
CsvStyle.QuoteAfterDelimiter
CsvStyle.QuoteAlways
Cube.AddAndExpandDimensionColumn
Cube.AddMeasureColumn
Cube.ApplyParameter
Cube.AttributeMemberId
Cube.AttributeMemberProperty
Cube.CollapseAndRemoveColumns
Cube.Dimensions
Cube.DisplayFolders
Cube.MeasureProperties
Cube.MeasureProperty
Cube.Measures
Cube.Parameters
Cube.Properties
Cube.PropertyKey
Cube.ReplaceDimensions
Cube.Transform
Culture.Current
Currency.From
CustomerInsights.Tables
DB2.Database
DataLake.Contents
DataLake.Files
DataWorld.Contents
DataWorld.Dataset
Date.AddDays
Date.AddMonths
Date.AddQuarters
Date.AddWeeks
Date.AddYears
Date.Day
Date.DayOfWeek
Date.DayOfWeekName
Date.DayOfYear
Date.DaysInMonth
Date.EndOfDay
Date.EndOfMonth
Date.EndOfQuarter
Date.EndOfWeek
Date.EndOfYear
Date.From
Date.FromText
Date.IsInCurrentDay
Date.IsInCurrentMonth
Date.IsInCurrentQuarter
Date.IsInCurrentWeek
Date.IsInCurrentYear
Date.IsInNextDay
Date.IsInNextMonth
Date.IsInNextNDays
Date.IsInNextNMonths
Date.IsInNextNQuarters
Date.IsInNextNWeeks
Date.IsInNextNYears
Date.IsInNextQuarter
Date.IsInNextWeek
Date.IsInNextYear
Date.IsInPreviousDay
Date.IsInPreviousMonth
Date.IsInPreviousNDays
Date.IsInPreviousNMonths
Date.IsInPreviousNQuarters
Date.IsInPreviousNWeeks
Date.IsInPreviousNYears
Date.IsInPreviousQuarter
Date.IsInPreviousWeek
Date.IsInPreviousYear
Date.IsInYearToDate
Date.IsLeapYear
Date.Month
Date.MonthName
Date.QuarterOfYear
Date.StartOfDay
Date.StartOfMonth
Date.StartOfQuarter
Date.StartOfWeek
Date.StartOfYear
Date.ToRecord
Date.ToText
Date.WeekOfMonth
Date.WeekOfYear
Date.Year
DateTime.AddZone
DateTime.Date
DateTime.FixedLocalNow
DateTime.From
DateTime.FromFileTime
DateTime.FromText
DateTime.IsInCurrentHour
DateTime.IsInCurrentMinute
DateTime.IsInCurrentSecond
DateTime.IsInNextHour
DateTime.IsInNextMinute
DateTime.IsInNextNHours
DateTime.IsInNextNMinutes
DateTime.IsInNextNSeconds
DateTime.IsInNextSecond
DateTime.IsInPreviousHour
DateTime.IsInPreviousMinute
DateTime.IsInPreviousNHours
DateTime.IsInPreviousNMinutes
DateTime.IsInPreviousNSeconds
DateTime.IsInPreviousSecond
DateTime.LocalNow
DateTime.Time
DateTime.ToRecord
DateTime.ToText
DateTimeZone.FixedLocalNow
DateTimeZone.FixedUtcNow
DateTimeZone.From
DateTimeZone.FromFileTime
DateTimeZone.FromText
DateTimeZone.LocalNow
DateTimeZone.RemoveZone
DateTimeZone.SwitchZone
DateTimeZone.ToLocal
DateTimeZone.ToRecord
DateTimeZone.ToText
DateTimeZone.ToUtc
DateTimeZone.UtcNow
DateTimeZone.ZoneHours
DateTimeZone.ZoneMinutes
Day.Friday
Day.Monday
Day.Saturday
Day.Sunday
Day.Thursday
Day.Tuesday
Day.Wednesday
Decimal.From
Diagnostics.ActivityId
Diagnostics.Trace
DirectQueryCapabilities.From
DocumentDB.Contents
Double.From
Duration.Days
Duration.From
Duration.FromText
Duration.Hours
Duration.Minutes
Duration.Seconds
Duration.ToRecord
Duration.ToText
Duration.TotalDays
Duration.TotalHours
Duration.TotalMinutes
Duration.TotalSeconds
Dynamics365BusinessCentral.Contents
Dynamics365Financials.Contents
DynamicsNav.Contents
Embedded.Value
Error.Record
Exasol.Database
Excel.CurrentWorkbook
Excel.Workbook
Exchange.Contents
Expression.Constant
Expression.Evaluate
Expression.Identifier
ExtraValues.Error
ExtraValues.Ignore
ExtraValues.List
Facebook.Graph
File.Contents
Folder.Contents
Folder.Files
Function.From
Function.Invoke
Function.InvokeAfter
Function.IsDataSource
Github.Contents
Github.PagedTable
Github.Tables
GoogleAnalytics.Accounts
GoogleBigQuery.Database
GroupKind.Global
GroupKind.Local
Guid.From
HdInsight.Containers
HdInsight.Contents
HdInsight.Files
Hdfs.Contents
Hdfs.Files
Html.Table
Impala.Database
Informix.Database
Int16.From
Int32.From
Int64.From
Int8.From
ItemExpression.From
ItemExpression.Item
JethroODBC.Database
JoinAlgorithm.Dynamic
JoinAlgorithm.LeftHash
JoinAlgorithm.LeftIndex
JoinAlgorithm.PairwiseHash
JoinAlgorithm.RightHash
JoinAlgorithm.RightIndex
JoinAlgorithm.SortMerge
JoinKind.FullOuter
JoinKind.Inner
JoinKind.LeftAnti
JoinKind.LeftOuter
JoinKind.RightAnti
JoinKind.RightOuter
JoinSide.Left
JoinSide.Right
Json.Document
Json.FromValue
Kusto.Contents
Kusto.Databases
LimitClauseKind.AnsiSql2008
LimitClauseKind.Limit
LimitClauseKind.LimitOffset
LimitClauseKind.None
LimitClauseKind.Top
Lines.FromBinary
Lines.FromText
Lines.ToBinary
Lines.ToText
List.Accumulate
List.AllTrue
List.Alternate
List.AnyTrue
List.Average
List.Buffer
List.Combine
List.Contains
List.ContainsAll
List.ContainsAny
List.Count
List.Covariance
List.DateTimeZones
List.DateTimes
List.Dates
List.Difference
List.Distinct
List.Durations
List.FindText
List.First
List.FirstN
List.Generate
List.InsertRange
List.Intersect
List.IsDistinct
List.IsEmpty
List.Last
List.LastN
List.MatchesAll
List.MatchesAny
List.Max
List.MaxN
List.Median
List.Min
List.MinN
List.Mode
List.Modes
List.NonNullCount
List.Numbers
List.PositionOf
List.PositionOfAny
List.Positions
List.Product
List.Random
List.Range
List.RemoveFirstN
List.RemoveItems
List.RemoveLastN
List.RemoveMatchingItems
List.RemoveNulls
List.RemoveRange
List.Repeat
List.ReplaceMatchingItems
List.ReplaceRange
List.ReplaceValue
List.Reverse
List.Select
List.Single
List.SingleOrDefault
List.Skip
List.Sort
List.Split
List.StandardDeviation
List.Sum
List.Times
List.Transform
List.TransformMany
List.Union
List.Zip
Logical.From
Logical.FromText
Logical.ToText
MailChimp.Collection
MailChimp.Instance
MailChimp.Tables
MailChimp.TablesV2
Marketo.Activities
Marketo.Leads
Marketo.Tables
MicrosoftAzureConsumptionInsights.Contents
MicrosoftAzureConsumptionInsights.Tables
MicrosoftAzureConsumptionInsights.Test
MissingField.Error
MissingField.Ignore
MissingField.UseNull
Mixpanel.Contents
Mixpanel.Export
Mixpanel.FunnelById
Mixpanel.FunnelByName
Mixpanel.Funnels
Mixpanel.Segmentation
Mixpanel.Tables
MySQL.Database
Netezza.Database
Number.Abs
Number.Acos
Number.Asin
Number.Atan
Number.Atan2
Number.BitwiseAnd
Number.BitwiseNot
Number.BitwiseOr
Number.BitwiseShiftLeft
Number.BitwiseShiftRight
Number.BitwiseXor
Number.Combinations
Number.Cos
Number.Cosh
Number.E
Number.Epsilon
Number.Exp
Number.Factorial
Number.From
Number.FromText
Number.IntegerDivide
Number.IsEven
Number.IsNaN
Number.IsOdd
Number.Ln
Number.Log
Number.Log10
Number.Mod
Number.NaN
Number.NegativeInfinity
Number.PI
Number.Permutations
Number.PositiveInfinity
Number.Power
Number.Random
Number.RandomBetween
Number.Round
Number.RoundAwayFromZero
Number.RoundDown
Number.RoundTowardZero
Number.RoundUp
Number.Sign
Number.Sin
Number.Sinh
Number.Sqrt
Number.Tan
Number.Tanh
Number.ToText
OData.Feed
Occurrence.All
Occurrence.First
Occurrence.Last
Occurrence.Optional
Occurrence.Repeating
Occurrence.Required
Odbc.DataSource
Odbc.InferOptions
Odbc.Query
OleDb.DataSource
OleDb.Query
Oracle.Database
Order.Ascending
Order.Descending
Pdf.Tables
Percentage.From
PlanviewEnterprise.CallQueryService
PlanviewEnterprise.Feed
PostgreSQL.Database
PowerBI.Dataflows
Precision.Decimal
Precision.Double
Projectplace.Feed
Python.Execute
QuickBooks.Query
QuickBooks.Report
QuickBooks.Tables
QuoteStyle.Csv
QuoteStyle.None
R.Execute
RData.FromBinary
Record.AddField
Record.Combine
Record.Field
Record.FieldCount
Record.FieldNames
Record.FieldOrDefault
Record.FieldValues
Record.FromList
Record.FromTable
Record.HasFields
Record.RemoveFields
Record.RenameFields
Record.ReorderFields
Record.SelectFields
Record.ToList
Record.ToTable
Record.TransformFields
RelativePosition.FromEnd
RelativePosition.FromStart
Replacer.ReplaceText
Replacer.ReplaceValue
Resource.Access
RoundingMode.AwayFromZero
RoundingMode.Down
RoundingMode.ToEven
RoundingMode.TowardZero
RoundingMode.Up
RowExpression.Column
RowExpression.From
RowExpression.Row
Salesforce.Data
Salesforce.Reports
SapBusinessWarehouse.Cubes
SapBusinessWarehouseExecutionMode.BasXml
SapBusinessWarehouseExecutionMode.BasXmlGzip
SapBusinessWarehouseExecutionMode.DataStream
SapHana.Database
SapHanaDistribution.All
SapHanaDistribution.Connection
SapHanaDistribution.Off
SapHanaDistribution.Statement
SapHanaRangeOperator.Equals
SapHanaRangeOperator.GreaterThan
SapHanaRangeOperator.GreaterThanOrEquals
SapHanaRangeOperator.LessThan
SapHanaRangeOperator.LessThanOrEquals
SapHanaRangeOperator.NotEquals
SharePoint.Contents
SharePoint.Files
SharePoint.Tables
Single.From
Smartsheet.Content
Smartsheet.Query
Smartsheet.Tables
Snowflake.Databases
Soda.Feed
Spark.Tables
SparkPost.GetContents
SparkPost.GetMetrics
SparkPost.Metrics
SparkPost.NavTable
Splitter.SplitByNothing
Splitter.SplitTextByAnyDelimiter
Splitter.SplitTextByDelimiter
Splitter.SplitTextByEachDelimiter
Splitter.SplitTextByLengths
Splitter.SplitTextByPositions
Splitter.SplitTextByRanges
Splitter.SplitTextByRepeatedLengths
Splitter.SplitTextByWhitespace
Sql.Database
Sql.Databases
SqlExpression.SchemaFrom
SqlExpression.ToExpression
Stripe.Contents
Stripe.Method
Stripe.Tables
SweetIQ.Contents
SweetIQ.Tables
Sybase.Database
Table.AddColumn
Table.AddIndexColumn
Table.AddJoinColumn
Table.AddKey
Table.AggregateTableColumn
Table.AlternateRows
Table.Buffer
Table.Column
Table.ColumnCount
Table.ColumnNames
Table.ColumnsOfType
Table.Combine
Table.CombineColumns
Table.Contains
Table.ContainsAll
Table.ContainsAny
Table.DemoteHeaders
Table.Distinct
Table.DuplicateColumn
Table.ExpandListColumn
Table.ExpandRecordColumn
Table.ExpandTableColumn
Table.FillDown
Table.FillUp
Table.FilterWithDataTable
Table.FindText
Table.First
Table.FirstN
Table.FirstValue
Table.FromColumns
Table.FromList
Table.FromPartitions
Table.FromRecords
Table.FromRows
Table.FromValue
Table.Group
Table.HasColumns
Table.InsertRows
Table.IsDistinct
Table.IsEmpty
Table.Join
Table.Keys
Table.Last
Table.LastN
Table.MatchesAllRows
Table.MatchesAnyRows
Table.Max
Table.MaxN
Table.Min
Table.MinN
Table.NestedJoin
Table.Partition
Table.PartitionValues
Table.Pivot
Table.PositionOf
Table.PositionOfAny
Table.PrefixColumns
Table.Profile
Table.PromoteHeaders
Table.Range
Table.RemoveColumns
Table.RemoveFirstN
Table.RemoveLastN
Table.RemoveMatchingRows
Table.RemoveRows
Table.RemoveRowsWithErrors
Table.RenameColumns
Table.ReorderColumns
Table.Repeat
Table.ReplaceErrorValues
Table.ReplaceKeys
Table.ReplaceMatchingRows
Table.ReplaceRelationshipIdentity
Table.ReplaceRows
Table.ReplaceValue
Table.ReverseRows
Table.RowCount
Table.Schema
Table.SelectColumns
Table.SelectRows
Table.SelectRowsWithErrors
Table.SingleRow
Table.Skip
Table.Sort
Table.Split
Table.SplitColumn
Table.ToColumns
Table.ToList
Table.ToRecords
Table.ToRows
Table.TransformColumnNames
Table.TransformColumnTypes
Table.TransformColumns
Table.TransformRows
Table.Transpose
Table.Unpivot
Table.UnpivotOtherColumns
Table.View
Table.ViewFunction
Tables.GetRelationships
TeamDesk.Database
TeamDesk.Select
TeamDesk.SelectView
Teradata.Database
Text.AfterDelimiter
Text.At
Text.BeforeDelimiter
Text.BetweenDelimiters
Text.Clean
Text.Combine
Text.Contains
Text.End
Text.EndsWith
Text.Format
Text.From
Text.FromBinary
Text.Insert
Text.Length
Text.Lower
Text.Middle
Text.NewGuid
Text.PadEnd
Text.PadStart
Text.PositionOf
Text.PositionOfAny
Text.Proper
Text.Range
Text.Remove
Text.RemoveRange
Text.Repeat
Text.Replace
Text.ReplaceRange
Text.Reverse
Text.Select
Text.Split
Text.SplitAny
Text.Start
Text.StartsWith
Text.ToBinary
Text.ToList
Text.Trim
Text.TrimEnd
Text.TrimStart
Text.Upper
TextEncoding.Ascii
TextEncoding.BigEndianUnicode
TextEncoding.Unicode
TextEncoding.Utf16
TextEncoding.Utf8
TextEncoding.Windows
Time.EndOfHour
Time.From
Time.FromText
Time.Hour
Time.Minute
Time.Second
Time.StartOfHour
Time.ToRecord
Time.ToText
TraceLevel.Critical
TraceLevel.Error
TraceLevel.Information
TraceLevel.Verbose
TraceLevel.Warning
Troux.CustomFeed
Troux.Feed
Troux.TestConnection
Twilio.Contents
Twilio.Tables
Twilio.URL
Type.AddTableKey
Type.ClosedRecord
Type.Facets
Type.ForFunction
Type.ForRecord
Type.FunctionParameters
Type.FunctionRequiredParameters
Type.FunctionReturn
Type.Is
Type.IsNullable
Type.IsOpenRecord
Type.ListItem
Type.NonNullable
Type.OpenRecord
Type.RecordFields
Type.ReplaceFacets
Type.ReplaceTableKeys
Type.TableColumn
Type.TableKeys
Type.TableRow
Type.TableSchema
Type.Union
Uri.BuildQueryString
Uri.Combine
Uri.EscapeDataString
Uri.Parts
VSTS.AccountContents
VSTS.AnalyticsViews
VSTS.Contents
VSTS.Feed
VSTS.Views
Value.Add
Value.As
Value.Compare
Value.Divide
Value.Equals
Value.Firewall
Value.FromText
Value.Is
Value.Metadata
Value.Multiply
Value.NativeQuery
Value.NullableEquals
Value.RemoveMetadata
Value.ReplaceMetadata
Value.ReplaceType
Value.ResourceExpression
Value.Subtract
Value.Type
Variable.Value
Vertica.Database
Web.BrowserContents
Web.Contents
Web.Page
WebAction.Request
WebMethod.Delete
WebMethod.Get
WebMethod.Head
WebMethod.Patch
WebMethod.Post
WebMethod.Put
Webtrends.KeyMetrics
Webtrends.Profile
Webtrends.ReportContents
Webtrends.Tables
Xml.Document
Xml.Tables
Zendesk.Collection
Zendesk.Tables
appFigures.Content
appFigures.Tables
comScore.GetReport
comScore.NavTable
comScore.ReportItems
tyGraph.Feed
tyGraph.NavTable
Published by PBIHub
SqlExpression.ToExpression
SqlExpression.ToExpression
SqlExpression.ToExpression(sql as text,environment as record) as text
results matching "
"
No results matching "
"