Forum Discussion

stansabel's avatar
stansabel
Frequent Visitor
10 years ago

Lookup data required is not available in an existing data source

There are times when the data available to Power BI in the database is not complete and cannot be augmented by joining another data source.  I can create an Excel workbook, download the key elements ...
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
10 years ago

Hi stansabel,

 

Based on my understanding, tables loaded into Power BI Desktop don't contain common fields, so that you are not able to join those tables, right?

 

In your scenario, you can export visual's data to CSV, then modify those CSV files with common fields added, then import data from CSV files into Power BI desktop. Each table can be integrated. See: Export data from Power BI visualizations.

 

You can also use Copy Table property to copy all tables data, then paste in a Excel worksheet. And modify Excel then import data into Power BI again. Please refer to screenshot below:

 

 

If you have any question, please feel free to ask.

 

Best Regards,
Qiuyun Yu