Warning if a query is not using parameters a expected

[Anonymous]

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

[parry2k · Accepted solution]

@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 · Accepted solution]

@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 

[Anonymous]

@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 · Accepted solution]

@Anonymous 

To help improve Power BI, share feedback via Ideas.

[Anonymous]

Done: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/40275742-warning-if-a-query-is-no...