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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Bhoobala_P,

Firstly, you can connect to files on Google Drive/Sheets from Power BI Desktop via Get Data->Web entry. Assume that you connect to a Excel file, open it in Google Sheet, go to File / Publish to Web,  then change the selection from Web Page to Microsoft Excel.  Copy the generated link and input the URL in Get Data->Web Window of Power BI Desktop, then enter your Google Drive/Sheet account and Password. For more details, please review the following screenshots.


Secondly, do you get expected result when using Get Data->Facebook entry to connect to your facebook data source?


Thirdly, based on my research, it seems that importing Doubleclick web URLs to Power BI Desktop doesn’t work as expected. Regarding to this issue, please vote it in the following links. As a temporary workaround for your issue, you can connect to Doubleclick data source from Excel and load data, then connect to the Excel file from Power BI Desktop.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/8470111-doubleclick-campaign-manager
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9274371-doubleclick-campaign-doubleclick-manager-reporting

 

 


Thanks,
Lydia Zhang