Add A Static Table Power BI

[bbotros77]

Hi There, 

I currently have power bi reports pulling data from a live data base (data change daily) , and on the other hand I have a few thouthands of entries that were not migrated into that data base and I keep them in a static table.

is there a way to incorporate that static table with the main data so I dun have to keep adding the static table numbers manually day i am pulling the report 

appreciate any advice 

[amitchandak · Accepted solution]

@bbotros77 , From an excel paste it on enter data  edit if needed

Create a dataflow and do not refresh dataflow. it will remain static

Power BI: How to Enter Data and Edit it- https://youtu.be/5nE7YGT72kU

[bbotros77]

I saw the video and understood how to add the data into power bi ... how to create that data flow to incorporate with current data in PBI , did you mean create relationship ?