Forum Discussion

chrishanfp's avatar
chrishanfp
Frequent Visitor
3 years ago

Gateway - ODBC Connection

Hi,   I am trying to setup a gateway and a new data source in Power BI Service with ODBC connector on premises.   I installed the gateway and it is showing ready for Power BI.     Then, ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi chrishanfp ,

Please try to use basic authentication method to create gateway datasource, in Power BI Desktop, also connect to Google BigQuery with this method.

There is a similar case you could refer: Solved: Re: Don't auth with auth2 to Bigquery - Microsoft Power BI Community

For more details, you can read related document: Google BigQuery connector - Power Query | Microsoft Learn

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

chrishanfp's avatar
chrishanfp
Frequent Visitor
3 years ago

Thank you, BinBin, but I could not retreive the dataset that is shared with my with the Google BigQuery Connector which was why I had to go through the ODBC Connector path.

 

I still tried to do it with basic authentication, but it was still the same.

I tried the json method as well, but I think it is applicable to the BigQuery Connector not, ODBC one.

 

 

Really do not understand why it does not work, as it is clearly working with Power BI Desktop.