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...
Eric_Zhang
Microsoft Employee
Microsoft Employee
I don't see that error by changing the datasource that way in your post. Please check your queries one by obe in "Edit Queries"->"Adavanced Editor" to ensure that only one database is invloved. By the way, you may consider to use Parameters instead of that way.
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
