Forum Discussion

Anonymous

Not applicable

5 years ago

OData connection error using Data Gateway

Hi All, I would like to test the ODATA connector using PowerBI as a source with "data gateway" (1) In powerbi.com - I have successfully configured the Data Gateway Cluster on the machine (On-Premis...

Anonymous

Not applicable

5 years ago

v-janeyg-msft
Community Support
5 years ago
Hi, Anonymous

Have you connected with the url 'http://.../Datasource_000008()' in desktop successfully?
Can you change the name 'Datasource_000008()' without using '_' and '()'? Maybe it can't be recognized.

Best Regards
Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Anonymous
  Not applicable
  5 years ago
  Hi v-janeyg-msft
  The URL http://localhost:9090/tagetikcpm/api/aih/data/v1/TGK_06/001/Datasource_000008
  without "()" works correctly with Power BI Desktop in the local machine (without Data Gateway service) but it doesn't work with Data Gateway.
  I can't remove the char "_" because it is not a valid URL.
  
  Regards,
  - v-janeyg-msft
    Community Support
    5 years ago
    Hi, Anonymous
    
    This shows that the problem is indeed the url format, because this kind of custom URL may not be accepted by PBI service. I want to know if the error in the service after you remove the (), is it still the same as before, or is it different? Have you tried changing odbc connector to web connector?
    
    Best Regards
    Janey Guo
    
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.