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
Anonymous's avatar
Anonymous
Not applicable
7 years ago

HI kaarel ,

For directquery mode, it will get last data from datasource when you interaction with visuals. I think these differences should more related to this 'sync' feature.

BTW, You can take a look at following link to know more about this:

Use DirectQuery in Power BI Desktop

Regards,

Xiaoxin Sheng

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?