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 qu...
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-msft
Community Support
Community Support