How do you access an integration dataset from a Linked Service in the workspace tab instead of the Linked tab in the Data Hub?

Question

I have a few Integration datasets with a connection from a linked service, in this case, Google AdWords, source dataset is a table from this linked service - Campaign. I am wondering how do I get this data into Power Bi - my ultimate goal here.

I have already linked Power Bi to our Synapse workspace and I can pull down the data from the workspace into Power Bi desktop.
I am able to go into the Develop section and access my power bi datasets and build a PBI report.

However, I am confused about how the data gets from the linked section in the data hub to the workspace section in my lake database or my SQL database. I am assuming I have to run a pipeline activity. I tried to generate a copy and lookup activity, however, I have not been successful with this or finding documentation to move forward.

I appreciate your assistance with this in advance.

Thank you,
Maria G.
Business Intelligence Developer
Total Mortgage Services, Inc.

Answer 1

Hello @Maria Giugno ,
Thanks for the question and using MS Q&A platform.

As we understand the ask here is to read the adword data and show the same in powerBI , please do let us know if its not accurate.
Let me start with pointing you to this document https://learn.microsoft.com/en-us/azure/data-factory/connector-google-adwords?tabs=data-factory .

<< quick text from the above link >>
Google AdWords as source
To copy data from Google AdWords, set the source type in the copy activity to GoogleAdWordsSource. The following properties are supported in the copy activity source section:

Also I wanted to call out the

I am not sure if you have already gone through this . You have not mentioned if you are doing any transformation on the data which you are getting .
Just to let you know that you can connect to Google Adwords directly from PoweBI also .
https://community.powerbi.com/t5/Desktop/How-to-Accessing-Google-Adwords-Campaign-Via-Power-BI/td-p/482026

Please do let me if you have any queries.
Thanks
Himanshu

---

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
  • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

Answer 2

This definitely helped to get google data in Power Bi > just not the data I need.

Thanks!