Making report from static to dynamic via building a single parameter.

[vivek3795]

Hey Guys,

I need help on Power Bi, that I saw in my organisation, the reports are more static and for publishing they have to make new DWID manually (the SP is call from SQL server). Is there a way in which we can convert this into dynamic report so that only one parameter will pass as a filter and all the DWIDs will be pass through that parameter while maintaining the privacy of data. This will cut down our multiple file publishing URL to just one type.

Any suggestion? 

The below is just an example of advanced editor for a particular table we are using,

let
Source = Sql.Databases("server number"),
ENTERPRISEDATA = Source{[Name="Name"]}[Data],
dim_FacilityDetails = ENTERPRISEDATA{[Schema="dim",Item="FacilityDetails"]}[Data],
#"Filtered Rows" = Table.SelectRows(dim_FacilityDetails, each ([DWID] = Dwid)),
#"Renamed Columns" = Table.RenameColumns(#"Filtered Rows",{{"FacilityName", "Facility Name"}})
IN
#"Renamed Columns"