Forum Discussion

Analitika's avatar
Analitika
Post Prodigy
5 years ago

Query contains unsupported function. Function name: if used query or function

amitchandak 

 

@ImkeF , @edhans @HotChilli 
Why Query contains unsupported function. Function name: if used query or function

 

If using Parameter  no errors appears.

 

Parameter1

Mydsn ' as parameter

 

= Odbc.DataSource("dsn=Mydsn", [HierarchicalNavigation=true])  ' no error

= Odbc.DataSource("dsn=" & Parameter1, [HierarchicalNavigation=true])  ' no error

 

= Odbc.DataSource("dsn=" & Odbc_dsn, [HierarchicalNavigation=true])  ' Query contains unsupported function. Function name: Odbc.DataSource

= Odbc.DataSource("dsn=" & settings[Column2]{0}, [HierarchicalNavigation=true])  ' Query contains unsupported function. Function name: Odbc.DataSource

 

Odbc_dsn ' Query

= settings[Column2]{0} ' from csv

 

How to use odbs source name from csv file?

Need Help
Tips and Tricks

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    5 years ago

    Analitika Can you post your Power Query from Advanced Editor? It looks like you are having an issue with an "if" statement but hard to tell.

    • Analitika's avatar
      Analitika
      Post Prodigy
      5 years ago

      Greg_Deckler 
      I already posted, i have no ifs just one row

       

      let
      Source = Odbc.DataSource("dsn=" & Odbc_DSN, [HierarchicalNavigation=true])

      in
      Source

       

      I think problem with Source as it can recieve only Parameters value but not dinamic, same problem with pPath is setted throught Parameter as static value it works, if dinamically from query or function it not work
      = Excel.Workbook(File.Contents(pPath& "\" & file_Name), null, true)