Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
LMN
New Member

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

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.

3 REPLIES 3
Idrissshatila
Super User
Super User

Hello @LMN ,

 

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💡

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




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. 

LMN_0-1692318242514.png

 

Hello @LMN ,

 

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💡

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.