Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
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]
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 5 | |
| 4 | |
| 4 | |
| 3 | |
| 3 |
| User | Count |
|---|---|
| 11 | |
| 10 | |
| 8 | |
| 7 | |
| 5 |