Forum Discussion

ViliusS's avatar
ViliusS
Frequent Visitor
1 year ago
Solved

Change ODBC data source settings in Power BI Service

We are using PowerBI Desktop to build our semantic models. All modeling work is performed on the local workstation where ODBC data source is configured to be reachable with `Driver={SQL Server};Serve...
Need Help
  • Deku's avatar
    Deku
    1 year ago

    You can you powerquery parameters to define the connection variables. You can then change the parameters from the semantic model after you publish, in semantic model settings 

Deku's avatar
Deku
Super User
1 year ago

You can you powerquery parameters to define the connection variables. You can then change the parameters from the semantic model after you publish, in semantic model settings 

ViliusS's avatar
ViliusS
Frequent Visitor
1 year ago

If I use parameter in DAX like this

Odbc.DataSource("Driver={SQL Anywhere 17};Host=" & Hostname & ";ServerName=test;DatabaseName=test", [HierarchicalNavigation=true])

 the DSN can no longer be managed via Data Source management UI. Are there better ways?

  • Deku's avatar
    Deku
    Super User
    1 year ago

    Not really