Forum Discussion
Solved
Data showing file name not what’s inside the files
Hi, I'm new to power BI and am making a power BI report, I have imported data from a MS Sharepoint folder (so it's in the cloud for my company and not local) and picked out the specific excel sheet...
each step create a table, you can refernece the table as many times as you want.
Here are reference #"Imported Excel Workbook" twice.
#"Imported Excel Workbook" = Excel.Workbook(#"test xlsx"), Tableau2_Table = #"Imported Excel Workbook"{[Item="Tableau2",Kind="Table"]}[Data], Custom1 = #"Imported Excel Workbook"{[Item="Tableau1",Kind="Table"]}[Data]Il table have the same columns, yiu can the append them.
latimeria
Solution Specialist
Solution Specialisteach step create a table, you can refernece the table as many times as you want.
Here are reference #"Imported Excel Workbook" twice.
#"Imported Excel Workbook" = Excel.Workbook(#"test xlsx"),
Tableau2_Table = #"Imported Excel Workbook"{[Item="Tableau2",Kind="Table"]}[Data],
Custom1 = #"Imported Excel Workbook"{[Item="Tableau1",Kind="Table"]}[Data]Il table have the same columns, yiu can the append them.