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

Maria Giugno 76 Reputation points
2022-03-17T16:25:11.733+00:00

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.

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,473 questions
0 comments No comments
{count} vote

Accepted answer
  1. HimanshuSinha-msft 19,381 Reputation points Microsoft Employee
    2022-03-18T19:17:17.803+00:00

    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 130616-image.png or upvote 130671-image.png 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
    1 person found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Maria Giugno 76 Reputation points
    2022-03-22T20:40:46.287+00:00

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

    Thanks!

    1 person found this answer helpful.
    0 comments No comments