Forum Discussion

Bhoobala_P's avatar
Bhoobala_P
Frequent Visitor
9 years ago
Solved

Connectivity to third party data sources

Dear Team, need your help on the following.   Does Power BI connect natively to: Google Drive / Sheets Facebook for Business Ads Manager Double Click If there is direct connectivity possible,...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Bhoobala_P,

    Firstly, it is not possible to use the sharable link (without output=xls) to connect with Power BI. If you worry about the security issue,  you may need to use Google's oAuth2 API, however, there are no official articles or blogs stating  this method. An idea about connecting to Google sheets in Power BI has been submitted in this link, please vote it up.

    Secondly, I am afraid that you are not able to directly connect to Facebook Ad Manager in Power BI,  there is also an idea about adding connectivity for Facebook Ad Manager, please vote it up.

    Thanks,
    Lydia Zhang

michaelbilling's avatar
michaelbilling
Helper II
6 years ago

Bhoobala_P Anonymous 

For the Facebook Campaing Manager Ads data - this is possible.

I just released a new version of my open sourced Facebook Ads connector.

The new release includes support for scheduled refresh on powerbi.com

A ready-to-go connector is available for download on my sponsor Scitylana's website, https://www.scitylana.com/connectors

Link to Gihub is available here too.