Forum Discussion
Relation between Direct Query Table and Import table stop working
cooler1978 , this should work.
Check is there a data type change for import or direct query table. Open power query and check there too.
Check the text for white space, trim the column.
Also problem is going out, the moment you change Direct Query mode to Dual or Import, and it's back the moment you turn out to Direct Query mode.
So the problem is for sure how the data (data types) is processing by Power Query in different modes, and from different table or data type in DB, in my case it's MSSQL DB.
So you have two option, as far as i understood - either you switch to Dual or Import mode whether it's possible or you add in Power Qury step with deleting spaces.
That's it.
But if somebody know better way or explanation - warmly welcome to post it)
cooler1978 , this should work.
Check is there a data type change for import or direct query table. Open power query and check there too.
Check the text for white space, trim the column.
If you mean relation column, there is no empty cells, there is no space and no changing type, both columns are text type in Power Query.
One table, imported, comes from DB as is, second, direct query, has some transforamtion, but no changing type:
let
Source = Sql.Database("192.168.1.33", "bi"),
Crossgroups = Table.SelectColumns(Source{[Schema="dbo",Item="Crossgroups"]}[Data],{"ID"}),
count = Table.RowCount(Crossgroups),
Pictures = Table.SelectColumns(Source{[Schema="dbo",Item="Picter"]}[Data],{"ID","IDobject","URLКартинки_FullSize"}),
count1=Table.RowCount(Pictures),
Filter = Table.Join(Table.RenameColumns(Pictures,{{"ID","Pictureid"}}), {"IDobject"}, Crossgroups, {"ID"}, JoinKind.Inner),
count2 = Table.RowCount(Filter),
Table = Table.RemoveColumns(Filter,{"ID"})
in
Table