So I have this table (call it Table1) where it has been formatted and converted into a long table.
I have this spreadsheet in Excel (call it SS1) where it is the same format from the original wide spreadsheet of Table1.
Was wondering if there's a way to append the data from SS1 onto Table1, applying all of its modifications made in Powerbi?
Solved! Go to Solution.
Hi @dragonus ,
On the query editor you can append several tables so this is possible you need to do the merge before the steps.
Assuming you have the following query:
What you need to do is to redo your query like this:
The two bold steps are the ones that you need to do what I ussually do is one of two things:
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsTry below steps in powerquery:
--Import 'SS1' into your PBI and name the table it lets say 'SS1'
--Go to 'Table1' (existing table in pbi), and in toolbar find append option, there you can either append 'SS1' to existing 'Table1' or you can create new 3rd table and append 'Table1' and 'SS1' data there.
Hope this helps.
Hi @dragonus ,
Just import SS1 into Power BI, select the source step in the applied steps of Table1, and then perform the append operation and select the SS1.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi @dragonus ,
Just import SS1 into Power BI, select the source step in the applied steps of Table1, and then perform the append operation and select the SS1.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Try below steps in powerquery:
--Import 'SS1' into your PBI and name the table it lets say 'SS1'
--Go to 'Table1' (existing table in pbi), and in toolbar find append option, there you can either append 'SS1' to existing 'Table1' or you can create new 3rd table and append 'Table1' and 'SS1' data there.
Hope this helps.
Hi @dragonus ,
On the query editor you can append several tables so this is possible you need to do the merge before the steps.
Assuming you have the following query:
What you need to do is to redo your query like this:
The two bold steps are the ones that you need to do what I ussually do is one of two things:
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsJoin us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
104 | |
74 | |
72 | |
48 | |
47 |
User | Count |
---|---|
160 | |
85 | |
80 | |
68 | |
67 |