How to connect a published dataset and subsequently merge with a data source

[Anonymous]

would like some advice for below to action:

1. connect to a published dataset ( I am the owner)

2. import another data source and merge with item1.

Thanking in advance.

[Idrissshatila]

Hello @Anonymous ,

for question 1, refer to this microsoft documentation where they explain the steps https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets

regarding question 2, you should import the new data set to the published dataset you're reading from.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡

[Anonymous]

Thanks. I can connect to the dataset to create a report. However, I would like to do some changes to the dataset (to merge with a new data source) , below textbox pop up when I click transform data. 

[Idrissshatila]

Hello @Anonymous ,

Then connect using direct query https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡