Excel Power Query Additional Table

[Anonymous]

Hello,

I've connected an excel spreadsheet to power bi using an excel power query. I importedthe linkage spreadsheet between my data spreadsheet and power bi. I have added tables to my data spreadsheet and would like to use the new tables in power bi visualizations but am not sure how to refresh/import/or upload the new tables using power query. 

How do I get new tables uploaded to power bi after I have already imported the excel power query file?

[jbwtp]

Hi @Anonymous,

If I understand your quesiton correctly:

1. You have some data stored in an Excel file

2. You have connected/imported data from this Excel data file to your Power BI model

3. This works fine, but this is just one table (or tab) out of many that you need to import/connect.

4. You would like to add another data table (or tables) from the same Excel file to your Power BI report.

If the ablve is correct that the simpliest way would be to walk through the same import process again, but this time select another tab/table and repeat until you have all of them imported to your PBI data model.

Kind regards,

John