Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
lukasker
Frequent Visitor

Enterprise Gateway cant configure ODBC data source

Enterprise Gateway cant configure ODBC data source when using Treasure Data, because it only uses api key instead of user and password,

meanwhile, form validates for password and wont let you go through

Please fix 

odbc_gateway.png

8 REPLIES 8
v-cherch-msft
Employee
Employee

Hi @lukasker 

Please check if below post could help you.

https://community.powerbi.com/t5/Service/Enterprise-Gateway-with-ODBC/td-p/98959

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Which part exactly?

To download personal gateway? We need enterprise one.

 

For now password needs to be validated when setting up and we cannot set it up properly.

 

Can you check if password validation can be removed?

Also on desktop is working flawlessly.

 

 

Hi @lukasker 

Based on my research,it is impossible to remove password validation.

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-cherch-msft 

Can you than provide a way to connect to odbc sources that only use api key (treasure data) instead of user and password?

Right now we have inconsistency beetwen desktop (no password validation and works) and service (password validation and not working).

Hi @lukasker 

Find some posts for your reference.

https://community.powerbi.com/t5/Integrations-with-Files-and/Using-a-REST-API-as-a-data-source/td-p/...

https://zappysys.com/blog/howto-import-json-rest-api-power-bi/

For 3rd party Links:

Please understand that this link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-cherch-msft 

The problem you referenced is for Pbi desktop which is working.

I have a problem with Pbi Service, where I am not able to either configure odbc source (with api key) for enterprise gateway, or add a odbc (with api key) datasource to dataflow.

 

Hi @lukasker 

I'm afraid i cannot find a better way to achieve that.If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Ok we allready did. Thx

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors