Forum Discussion
Post PatronAlternative to merging tables
You could merge the tables on the SQL server already, and if possible even do some calculations already. The more calculations you dont have to do in Power BI the better the performance.
Post PatronAnonymous first of all, thank you for your help.
That is right, currently, on each MS SQL server, there is 1 PBI database where I store the dynamic query results. Then PBI, is quering each of those 3 databases and merging the 3 tables into 1 large table.
I believe this process could be optimized and be faster.
Probably, as you first suggested, it would be best to create a table in 1 MS SQL server and store the data, from each server, in that table. Then, PBI will only query 1 table.
As for creating a relationship between each table, what is your suggestion ?
Thank you again.
Post PatronAnonymous Thank you again,
the more I think about, the more I am convinced that running the merge in the SQL server is the way to go, definetely a better approach. So, I accepted your first reply as the solution to this post, thank you.
Thankyou!
And yes i do believe that is the best option. Also consider doing calculations there. SQL server is way faster then PBI for that kind of stuff.- EVEAdmin
Anonymous most welcome,
in SQL, as far as calculations go, all I need to do, on this specific report, is some GROUP BY to aggregate records by month and year. Simple enough.