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.
Hi to everyone!
I have been searching around and I could find something that was able to use as solution (probably I am too noob)
The Case
I try to combine multiple excel which contain data sheets.
The size is big and the rows many many....
I am at loading process for about 5 hrs now!
for example biscs_ean is data combination from multiple files name &_2019, &_2020, &_2021, &_2022 (which are not to be refreshed) and &_2023 which is to be updated in time to time.
biscs_ean is appended query by 2 queries, old files and 2023 file.
The only fquery that has Load activated is biscs_ean
this is the deal for the rest files.
Question 1.
Is there a way (understandable) that I could reduce time of uploading?
Question 2.
If I add a new query/table, is there a way that can Close & Apply, but the load process apply only to the new and avoid reloading?
I want the older tables to be available in data model.
Question 3.
If I update data in files _2023, can I refresh the specific data only, without biscs_ean gets data from _2019 (etc) again?
In general avoid reloading all over again.
Thanks in advance for your time and your help!
Solved! Go to Solution.
the solution was to make the appropiate selection about loading and refreshing. The most important was to upload each file and not folders.
In the tables you are appending together, remove the check box on the 'Include in report refresh' for all that won't need to be refreshed.
the solution was to make the appropiate selection about loading and refreshing. The most important was to upload each file and not folders.
for example, all files about 2019 to 2022, Load and refresh are deactivated.
file that is about 2023 is load deactivated
the issue remains.... is been 2 hrs since my post
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 |
---|---|
97 | |
96 | |
82 | |
74 | |
66 |
User | Count |
---|---|
121 | |
105 | |
102 | |
82 | |
72 |