Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Sign up nowGet Fabric certified for FREE! Don't miss your chance! Learn more
I am using this query and instead of seeing data I get the following error.
Expression.Error: The column 'Data' of the table wasn't found.
Details:
Data
I suspect that I am not assenbling the string correctly with the dash ( - )
let
week = Date.WeekOfYear(DateTime.LocalNow()),
year = Date.Year(DateTime.LocalNow()),
strWeek = Number.ToText(week,"D2"),
strYear = Number.ToText(year,"D4"),
fullDate = Text.Combine({strYear, strWeek}, "-"),
Source = Odbc.DataSource("dsn=SystemDSN_ELK_PROD", [HierarchicalNavigation=true]),
gsec_Database = Source{[Name="gsec",Kind="Database"]}[Data],
#"data-varonis_Table" = gsec_Database{[Name="data-varonis-"&fullDate,Kind="Table"]}[Data]
[Data]
in
#"data-varonis_Table"
Solved! Go to Solution.
@Anonymous
why do you have duplicated [Data] here ?
#"data-varonis_Table" = gsec_Database{[Name="data-varonis-"&fullDate,Kind="Table"]}[Data]
[Data]
@Anonymous
why do you have duplicated [Data] here ?
#"data-varonis_Table" = gsec_Database{[Name="data-varonis-"&fullDate,Kind="Table"]}[Data]
[Data]
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 12 | |
| 11 | |
| 11 | |
| 7 | |
| 6 |