Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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"
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
143 | |
104 | |
104 | |
80 | |
66 |