Issue with the UserID parameter in local report vs Published report in PowerBI Services
Hi Everyone, Hope everyone doing well! We are using parameters in the Power BI Report Builder paginated report. A parameter was created with the following code: ="[table].[columnname].&["+ User!UserID +"]" In the default values, we used a specific Values above expression, These parameters are being passed into the embedded dataset, and the report is working locally for a specific user. The source is an MDM cube using an MDX query. While the report works locally in the Power BI Report Builder application, when published to Power BI Service, it is not working. Instead of showing the system UserID in the parameter values, it displays the email ID of the Power BI Service. We need the system ID to appear in the parameter values so it can be passed into the dataset for the report to work. For the UserID, it is showing the system name locally, and we need the same behavior in Power BI Service. Thanks in advance
Multiple report parameters don't filter tablix
The following report parameters are available: Show Contacts & Employment are only to show/hide certain columns. Industry, County, and Country are all similarly structured: and are all listed in the dimension table of the query designer: as well as the parameters pane of the dataset properties: The dataset itself is a Power BI semantic model: where IAServiceSplit is essentially the same columns from the account table split by comma into new rows (an account can have multiple industries, ex. Composites / Advanced Materials, Marine, OEM My issue is the report table doesn't filter from the Industry parameter. Ex. selecting all industries (including ""), filtering to Germany, all counties filters to all German accounts. Then applying an industry filter does not further filter the table (even when clicking view report). This report is inteded to be used as a PBI Report Builder visual with PBI slicers for the corresponding report parameters.
