service
25 TopicsAll you need to know about Power BI report Server and Power BI service
This will be the first in-person meeting of this User Group. ๐๐๐๐ฉ๐๐ฃ๐ ๐ก๐๐ฃ๐ :https://t.me/PersianPBIUG ๐๐๐ง๐จ๐๐๐ฃ ๐๐ฝ๐๐๐- ๐๐๐๐ง๐ค๐จ๐ค๐๐ฉ ๐พ๐ค๐ข๐ข๐ช๐ฃ๐๐ฉ๐ฎ: https://bit.ly/3IAg7xT ๐๐๐ฃ๐ ๐๐๐๐ฃ: https://bit.ly/32tGkif ๐๐ค๐ช๐๐ช๐๐: https://bit.ly/3hk20RL Language: Persian - Farsi90Views0likes0CommentsVisual-level filters disappear after republishing from Power BI Desktop
In Power BI Desktop, I added a new section to my existing dashboard. For this section, I copied visuals from a previous section, renamed them, changed the fields to new dataset fields, and applied new visual-level filters using the Filters pane. Everything looks correct in Desktop, but after publishing the updated report to the Power BI Service, the new filters are missing. If I publish the same report as a new one to a different workspace, the filters appear correctly. Has anyone faced this issue before or know how to fix it without deleting and republishing the report?Solved4.1KViews1like11CommentsManage access to reports connected to same dataset with common RLS bucket
Hi All, I possess a primary dashboard that contains several RLS buckets and is utilized by the designated group of users. Currently, there is a requirement to establish a restricted view, allowing access to only one page of the main dashboard, as the audience falls outside the targeted group. I prefer not to hide views and subsequently manage user mapping to accomplish this; hence, I have created an additional report by linking to the dataset of the main dashboard, which alleviates concerns regarding the duplication of any data, measures, or query modifications. At this point, when I grant access by adding names to the dataset's RLS bucket, it enables viewing on both reports: the main dashboard and the restricted one. This situation persists even after I remove users from the audience of the first dashboard using Manage Access. Need urgent help on this pls. Thanks a lot.Solved1.1KViews0likes8CommentsMigrating Paginated Reports from PBI RS to Service - invalid parameter
Greetings, After spending an inordinate amount of time triaging errors when migrating reports from PBI RS to the Service, I thought I would save folks some time and share my experience in resolving the "invalid parameter" error message that kept creeping up after report migration and setting up the data source connection to the Gateway. Process 1) Publish report to Power BI via the Report Manager in PBI RS - no errors 2) Connected to Data Source via Enterprise Gateway 3) Ran the report in which the parameters appeared to be populated correctly but then failed 4) Error message indicating "invalid parameter" (more below but not exhaustive) We used to have a standard of entering developer comments (using -- before each line) in the Oracle SQL used in the Datasets of the Paginated reports. Colons were also used in the comments to delineate values after the "field names" as we could parse the strings for reference/inventory management. This worked well for the reports published to PBI RS (on-prem) but once published to the Service, the interpreter ignored the dashes of the comments which caused the colons to be evaluated as an Oracle parameter value. The solution was to remove the comments as they are no longer required which resolved the in the Service. Environments: * SQL Server 2016 * PBI RS Version1.19.8779.19175(January 2024) Data Warehouse (Dataset Query DB) * Oracle 19c Paginated Reports: * Shared Report Parts * Shared Data Source * SQL and Query Parameters used in Datasets Portion of Error Message: Unable to render paginated report A data source used by this report returned an error. If you continue to experience this error contact the report author or data source owner quoting: DM_GWPipeline_Gateway_ProviderDataAccessArgumentError. Received error payload from gateway service with ID 139675: Async operation fedca7d6-a82d-45f2-8cfb-deb0b37f96db is faulted with [0]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.DataAccessUserErrorDueToArgumentException: Failed to access target data source because at least one of the passed arguments is invalid. Please check the data source connection string. GatewayPipelineErrorCode=DM_GWPipeline_Gateway_ProviderDataAccessArgumentError GatewayVersion=3000.226.5 ---> [1]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.GatewayPipelineWrapperException: Substituted: ArgumentException:<ccon>Invalid parameter binding Parameter name: adatar</ccon> GatewayPipelineErrorCode=DM_GWPipeline_UnknownError GatewayVersion= InnerType=ArgumentException InnerMessage=<ccon>Invalid parameter binding Parameter name: adatar</ccon> InnerToString=<ccon>System.ArgumentException: Invalid parameter binding Parameter name: adatar I hope this information saves others time as they migrate paginated reports from on-prem to the cloud. -LiamSolved1.2KViews1like1CommentVisual Similar to Gantt Chart
Hello- I am looking for a visual that can allow me to automate this view in Power BI: Currently, the raw data is in row format with Start Date, End Date, Event Type, Event Name, and more columns. I would like the calendar year view on one screen with Event Type on the y axis and the Event Name in the chart. I have come close by trying a Gantt Chart. Below is the result of using PowerGantt Chart: However, the Gantt Chart lacks the following: Grouping: I would like Event Type to be the only Y axis with Event Title in the chart. Side by Side: Events side by side if they are under the same grouping PowerGantt Chart is the best option so far but it requires a paid license; the Microsoft Gantt Chart is not as strong (Rolls up to Day view max, not month)/Axis cannot be expanded That being said, is there a visual that mimicks the view of a Gantt Chart while fulfilling these needs? Thanks!3.1KViews0likes3Comments