PBI services Odbc.DataSource dynamic dsn name

Question

In PBI desktop file no errors, erro appear only in PBI service on refreshing

ERROR:

Query contains unsupported function. Function name:Odbc.DataSource

Parameter1

Mydsn ' as parameter

used as text - not dynamic

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

as used us text Parameter - not dynamic

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

 

Odbc_dsn ' Query

= settings[Column2]{0} ' from csv

from csv query

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

directly from csv table

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

• No one of Privacy settings is not change anything, tryied all available ways. (change to none, private, organizational, public, disabling privacy settings and etc)

How to use odbs source DSN name from csv file?

Answer 1

Dsn name can be only static and only string