Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Teradata LDAP source; Cloud Refresh not working

I have Power BI reports connected to Teradata via ODBC because they use LDAP. These reports connect via the GUI/M code. The data refreshes fine in Desktop, but when Publishing to PBI Service the refr...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

HI MatthieuJC,

 

Which error are you encountering with when you refresh your report? You say "with M code not refresh but will SQL can", could you please clarify more details about "M code"?

 

Regards,

Jimmy Tao

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thanks for your response, v-yuta-msft.

     

    The error is usually a timeout error at the two-hour mark.

     

    What I meant when I said it will refresh with custom sql code but not with M is that if the connection is setup using M/Power BI GUI, the refresh will always timeout whereas if I connect and put in a custom sql statement like Select * From SomeDatabase.SomeTable, it will refresh, even if I do some M afterwards like remove columns.

    Ie- 

    let
    Source = Odbc.Query("dsn=Prod Teradata", "select #(lf)*#(lf)from SOMEDATABASE.SOMEVIEW"),
    #"Filtered Rows" = Table.SelectRows(Source, each ([Department ID] = 2 or [Department ID] = 4 or [Department ID] = 14))
    in
    #"Filtered Rows"

    refreshes in cloud but 

    let
    Source = Odbc.DataSource("dsn=Prod Teradata", [HierarchicalNavigation=true]),
    SOMEDATABASE_Schema = Source{[Name="SOMEDATABASE",Kind="Schema"]}[Data],
    SOMEVIEW_View = SOMEDATABASE_Schema{[Name="SOMEVIEW",Kind="View"]}[Data]
    in
    SOMEVIEW_View

    does not.

    • v-yuta-msft's avatar
      v-yuta-msft
      Community Support
      8 years ago

      Hi MatthieuJC,

       

      Odbc.Datasource is different from Odbc.Query. It returns a table of SQL tables and views from the ODBC data source specified by the connection string, but doesn't return and load the table into power bi. 

       

      In addtion, M code can only be used in power bi to shape and transform data. It can't be used to load external data source.

       

      Regards,

      Jimmy Tao 

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        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.