I Need to add new table to existing dataset.

[Anonymous]

I need to add data to existing dataset. So i have downloaded Power Bi PBIX file and opened in Power BI Desktop and clicked on transform data and clicked on get and added new through direct from sql server and after i try to click close and apply. I am getting there nor relation to the table table. any please How to manage relationship from power query before applying changes? I couldn't

[v-robertq-msft · Accepted solution]

Hi, @Anonymous 

According to your description, do you mean that you want to manage the relationships between the newly added data table and the original tables?

If so, you can just click on the “Close and apply” option to import the data table into the Power BI first, then go to the “Model” view to add and manage the table relationship manually.

You can follow this document:

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SanketBhagwat]

Hi @Anonymous .

By what I understood from your query, I think you are trying to combine live data with any other imported data.

If so, Power BI doesn't allow to combine both forms of data.

However there is a way to do the same.

Please refer https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models#:~:text=When%20you%20use%20DirectQuery%2C%20composite,DirectQuery%20sources%20and%20import%20data.

Regards,

Sanket Bhagwat.

If I have answered your question, please mark this as accepted so that it can help others.

[Anonymous]

Hi, 

I connected to PBiX file and i can view the data in Power Query for existing tables.

[aj1973]

Can you please screenshot your Model?

[aj1973]

Hi @Anonymous 

Did you first connect your Pibx file to the source?