Forum Discussion

santiagomur's avatar
santiagomur
Resolver II
6 years ago
Solved

use parameters in sql query to import data

hi,    i`m trying to use parameters to import data, what i need is to use parameters to change de WHERE in de query.  I am creating a theme and i want that when i open it they ask me this paramete...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • JirkaZ's avatar
    JirkaZ
    6 years ago

    Anonymous And here you go - Feb update with Incremental Refresh for PRO users 🙂

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Anonymous just out of curiosity, how did you solve the incremental refresh? Because I tried to have one big table with "old" data and one smaller for recent data, then instructed PBI to load only the small one and then concatenate them. No matter how hard I tried, PBI always refresh everything - I suppose it's a way MS implemented to avoid people working with incremental refresh without buying the Premium...

JirkaZ's avatar
JirkaZ
Solution Specialist
6 years ago

Anonymous Just disabling the "Include in Report Refresh" should cause the engine to not refresh the larger table.
However this "manual" incremental refresh is kinda hard to achieve since from time to time you have to "flush" the data to the "archive" data source and hence update it all.