Forum Discussion
Teradata LDAP source; Cloud Refresh not working
v-yuta-msft I appreciate the response.
I'm not sure I fully understand how this would impact refreshing in the cloud vs refreshing in Desktop. I did not code these myself: they were autogenerated M statements from the GUI. On one, I selected Get Data; ODBC; chose Server (PROD TERADATA); Selected the Database and View; on the other, I selected Get Data; ODBC; chose Server (PROD TERADATA); added a custom sql statement (Select * From Database.TheView).
Both refresh in Desktop fine, but when published to the cloud, only the query with the custom sql statement will refresh- the other will hit the 2 hr timeout limit and fail.
I have not experienced this with other datasources so i'm wondering if this is an issue with ODBC, with Teradata, with LDAP, with company specific security, with the gateway, or some other reason.
Hi MatthieuJC,
When the report\dashboard in PBI service need to be refreshed, PBI service will send a encrypted message which contains query statement to gateway, then the gateway search the data source through AD and send the query to data source. The first query is a SQL query statement which can be recognize by power bi service. But the second M code is not a SQL query statement which can't be recoginzed by PBI service , encrypted and sent to gateway.
This link about how PBI service interact with gateway for your reference:
https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem-indepth.
Regards,
Jimmy Tao