Forum Discussion

karaoan's avatar
karaoan
Kudo Kingpin
10 years ago

Simplifying using same dashboard(pbix) file with different databases

  We would like to provide our users with a generic dashboard (pbix file) that can be used with their database (all our customer databases run on the same SQL Server but each customer of course has ...
Need Help
karaoan's avatar
karaoan
Kudo Kingpin
10 years ago

I have experimented some more and come again across the problem that my credentials are rejected although they are 100% correct. I have created a Power Bi query script with the variable for the database name (blank query with the string for the database as proposed by Chris Webb: http://blog.crossjoin.co.uk/2015/11/09/avoiding-duplication-of-database-connection-information-in-power-bi/) and the query for the table:

 

let
    Source = Sql.Database("servername",Databasename),
    dbo_VW_InvoicesAndCredits = Source{[Schema="dbo",Item="VW_InvoicesAndCredits"]}[Data]
in
    dbo_VW_InvoicesAndCredits

("servername" on our end uses the real server name)

 

After that I am queried for user name and password which I enter correctly but it gets always rejected (on a new query it works perfectly). I am really getting to the end of my patience this seems to be an error in Power BI Desktop???