Forum Discussion
Helper IIIAppend Querry DB2 and Txt File not working
Hi Icey thank you for your idea I was able to bypass the issue since it was all about performance. By adding the DB2 source, the performance of loading time for the data deteriorated quite significantly. So What I did was that I refreshed the model before the data entered the DB2 and appended query with .txt.
Since it had 0 rows on DB2 the appending worked fine and then I moved the model to reporting server which has much higher computing power then my Laptop and scheduled a refresh there with the full DB2 data. Now it is working fine as the update is happening on the server.
Community SupportHi stanislav_dugas ,
Please try to create a new .pbix file, connecting to DB2 directly and appending with the .txt file. Will the issue still appear?
In addition, how about using Table.Buffer to buffer a table in memory, isolating it from external changes during evaluation?
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
Helper IIIHi Icey thank you for your idea I was able to bypass the issue since it was all about performance. By adding the DB2 source, the performance of loading time for the data deteriorated quite significantly. So What I did was that I refreshed the model before the data entered the DB2 and appended query with .txt.
Since it had 0 rows on DB2 the appending worked fine and then I moved the model to reporting server which has much higher computing power then my Laptop and scheduled a refresh there with the full DB2 data. Now it is working fine as the update is happening on the server.
- Icey
Hi stanislav_dugas ,
Glad to hear that! Please accept your reply as the solution. Your contribution is highly appreciated.😉
Best Regards,
Icey