Forum Discussion

kaarel's avatar
kaarel
Icon for Resolver I rankResolver I
7 years ago

Direct Query on top of SQL 2017 view gives wrong results

Hi!   I've got a complicated SQL View, which has STRING_SPLIT and window functions (LAST_VALUE). It also uses another view. Power BI Direct Query gives different results than Sql Server Manageme...
Need Help
kaarel's avatar
kaarel
Icon for Resolver I rankResolver I
7 years ago

Hi! The underlying data is static when testing the queries via SSMS and Power BI Desktop. Is there any documentation about the limitations when using SQL Views with window functions, string_split() or referenced views in Power BI Direct Query mode? Best Wishes, Kaarel.

kaarel's avatar
kaarel
Icon for Resolver I rankResolver I
7 years ago

Anyone?