Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello, everyone
i have some performance problems!
my data model is
these data are on the Sharpoint folder
file A 800MB data from 2010-2015
file B 800MB data from 2016 - 2020
file C 200MB data from 2021
all files have the same columns, A and B are not updated, only C
With a Sharpoint folder connection I get a file, but I cannot switch off A and B for the update
how can i improve this?
Solved! Go to Solution.
Hi @Hikmet_JCI
Duplicate the Sharpoint folder table:
Set as:
Apply a filter in the duplicate table:
Set as:
If you still have some question, please don't hesitate to let me known.
Best Regards,
Link
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
Hi @Hikmet_JCI
Duplicate the Sharpoint folder table:
Set as:
Apply a filter in the duplicate table:
Set as:
If you still have some question, please don't hesitate to let me known.
Best Regards,
Link
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
Use incremental refresh based on the Last Modified Date of the files. Ignore the Query Folding warnings.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
82 | |
70 | |
63 |
User | Count |
---|---|
145 | |
111 | |
104 | |
84 | |
64 |