Forum Discussion
Changing datasource in Direct query mode
Hi I am now authoring Power Bi report connecting to SQL Azure database using direct query. We frequently create new databases, so I should change data source whenever a new database is created. I...
Hi Eric
It generally works okay, but sometimes the error occurs and I do not know why.
Maybe I should change the way I use datasource as you directed - using Parameters.
I have same issue... I managed to make it go away by removing the one parameter I had on the report
(it was called username, with value username() )
luckily i dont need it right now.
but It does seem there is a bug when checking multiple sources.. as it shoulnd fail on a parameter value