Coming into someone elses work and having some trouble finding where the query is embedded in power bi. Hoping someone can point me in the right direction.
My previous experience is that I can modify data queries and connections 2 ways - either through the "transform data" option or editing the advanced connection string/query by editing the data table source.
However, in the report ecosystem I am working with, the "transform data" just leads me to the "data hub" and a "dataset icon" that only has the user/pass/connection details, no advanced query, etc. When I go to edit table, and source, same thing - no query.
But I know the data is feling filted through some sort of selection or query by what is coming across into Powerbi.
This is pro license bilt on desktop published to service, some data flows in use, but this particular data I am looking to change the "where" filters on all link to the "dataset" on which I can only find the modification for the gateway and the credentials; not the query.
Any help would be appreciated.
