Connection to Google Drive and NetSuite

[Yuchenapril]

Hi All,

I am tasked by my manager to explore if it is possible to connect Power BI to data saved in Google Drive and to ERP system NetSuite. After searching through the internet, I don't find a satisfactory answer. I am trying my luck here.

Thank you.

[Icey · Accepted solution]

Hi @Yuchenapril ,

You can try these ways:

1. Connect to Google Drive and NetSuite as ODBC Data Sources by purchasing ODBC Drivers. Reference: 

Author and Share Power BI Reports on Real-Time Google Drive Data (cdata.com);

Author and Share Power BI Reports on Real-Time NetSuite Data (cdata.com);

NetSuite Power BI Connector - CData Software.

2. Leverage Google Drive's shared link and NetSuite’s Web Query report functionality. Reference:

Connect a Google Sheet spreadsheet to Power BI as a data source | NateChamberlain.com;

Connect NetSuite to Power BI - DataChant.

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.