Forum Discussion
Alternative to appending Data - SQL databases to Power bi best practice
Hello please can some one give me some guidance?
I'm trying to create a power bi report that uses Data from 3 SQL databases EU, UK and USA. The databases are set up Identically (table names, columsn etc).
Im having issues whenever I need to report on all 3 databases currently I use the SQL server connection and pull in all the tables I need then build relationships and vizuals for each database.
When looking online it says I should append the data tables roughly 10 tables some with thousands of rows for each database. however when appending Power Bi runs but cant finish the append for 1 table.
I need to be able to report on every row in each of the 3 identical tables but cant find a way of doing this?
Is there a way to report on all 3 databases in 1 set of visuals?
Do I need to run the queries in Excel before hand and manipulate the data before connecting to power bi, If so is there a way to automate the data refreshes?
Any help would be greatly appriciated as I've been stuck on this for a while.
2 Replies
Jamie_Macca , Try to test this operation in dataflow on power bi service and see if it works better.
If you are fabric trial you do that in data flow gen2 or you load data in the warehouse and append those into new table.
Thanks amitchandak Will give this another try, it was proving quite tricky to do. when I tried it the other day
