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};Server=hostname.domain.tld`. However when we upload prepared semantic model to PowerBI Workspace online we need to use hostname "localhost" as that on-premise database is reachable via PowerBI Data Gateway which is installed on the SQL server directly.

 

Is there a way to change ODBC data source server name in the PowerBI Service somehow? I can only map already embedded data source with its original settings.

Are there any better ways to do such workflow, without using dataflows?

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 

3 Replies

  • 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?