Forum Discussion

BobF's avatar
BobF
Helper I
10 years ago
Solved

Data Source and other frustrations

My scenario is this.   Three clients each set up with Power BI accounts, works fantastic.   One Azure database, one Admin account, and three accounts set up which match the three client accounts ...
  • BobF's avatar
    10 years ago

    Got one answer ( l think today whilst playing) 

     

    M source 'Source = Sql.Database("mydatabaseServer.database.windows.net,1433", "mydatabaseName"),'  Yes this is the same as the data source name that is listed in the 'Data Source Settings' window.  This setting is also Case Sensetive.