Forum Discussion
Incorrect errormessage can´t create a relationship between two columns because one of the columns ..
Hi Phil,
some extra information
I use views in sql server as sources for powerbi.
When I remove the where DD.FullDate <> '0001-01-01' from that view and refresh the data in powerbi I get the error 'Column Fulldate' in table SiteEventDate' contains blank values and this is not allowed for columns on the one side of the many-to-one relationschip ...
When I add the where clause again in my view I can load the data without problems.
Hi Phil,
The source is a dimension table in my sql database.
the definition:
let
Source = Sql.Database(SqlServerInstancename, "MyDbName"),
dbo_SiteEventDate = Source{[Schema="dbo",Item="SiteEventDate"]}[Data],
#"Duplicated Column" = Table.DuplicateColumn(dbo_SiteEventDate, "CalendarQuarter", "CalendarQuarter - Copy"),
#"Renamed Columns" = Table.RenameColumns(#"Duplicated Column",{{"CalendarQuarter - Copy", "CalendarQuarterQ"}}),
#"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"CalendarQuarterQ", type text}}),
#"Added Prefix" = Table.TransformColumns(#"Changed Type", {{"CalendarQuarterQ", each "Q" & Text.From(_, "en-GB"), type text}}),
#"Removed Duplicates" = Table.Distinct(#"Added Prefix", {"FullDate"})
in
#"Removed Duplicates"
Hi Phil,
some extra information
I use views in sql server as sources for powerbi.
When I remove the where DD.FullDate <> '0001-01-01' from that view and refresh the data in powerbi I get the error 'Column Fulldate' in table SiteEventDate' contains blank values and this is not allowed for columns on the one side of the many-to-one relationschip ...
When I add the where clause again in my view I can load the data without problems.