Forum Discussion
Warning if a query is not using parameters a expected
Hi
I use parameters to ask for sql server and database, when I open my pbix file.
Is there anyway to display all datasorces used by the report - in the report?
The purpose is to be warned, if a query - by mistake - is NOT using parameters, and thereby gets its data from another server/database, than the ones entered as parameters. Regards, Henrik
Anonymous, unfortunately, I don't think there is a way to get the metadata, I guess you open each query and update the parameter value for server/database, that way at least all the queries will have the same server/DB
4 Replies
- parry2k
Super User
Anonymous, unfortunately, I don't think there is a way to get the metadata, I guess you open each query and update the parameter value for server/database, that way at least all the queries will have the same server/DB
parry2k Alas. The problem is, when I forget to use parameters - maybe just in one out of many queries. Working with many reports, it would be nice with a reminder, because in a few situations, I've been struggling with a report, couldnt figure out why some numbers where wrong - until I saw, that a single query was looking at a wrong source, not using the parameters.
v-chuncz-msftCommunity Support