Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    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 

  • v-chuncz-msft's avatar
    v-chuncz-msft
    6 years ago

    Anonymous 

     

    To help improve Power BI, share feedback via Ideas.

     

parry2k's avatar
parry2k
Super User
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

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.