service
12 TopicsVisual-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.1KViews1like11CommentsMigrating 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.2KViews1like1CommentDirect Query MariaDb not working in Power Bi Online
Hi! I currently am using Direct Query with MariaDb and on the Desktop version everything is working fine, but when publish the report to the online environment i get the following error message and all the visuals are white. Cannot load the model Cannot load the model schema associated with this report. Check that the server connection is active and try again. Check the technical details for more information. When contacting support, provide these details. Does anyone may know what is causing this problem? Thanks in advance - Willem1.9KViews0likes4CommentsDirect Query Power Bi online service
Hey all! I have a problem what is somewhat still unclear for me; i am using MariaDb with a direct query connection on Power Bi Desktop and everything is working fine. when i want to Publish the file to the Power Bi online service, all the visuals online are just white and i get the following error message: ____ Cannot load the model Cannot load the model schema associated with this report. Check that the server connection is active and try again. Check the technical details for more information. When contacting support, provide these details. Onderliggende fout: PowerBI service client received error HTTP response. HttpStatus: 400. PowerBIErrorCode: DatasourceAnalysisFailedWithUnknownFunctions Activiteits-id: 5d9cae4d-6646-4f80-95e9-1743b834869d Correlatie-id: 7d57e84e-f3d7-7030-4fc6-e2bc6db8494c Aanvraag-id: 11dcd3a4-9bed-6ffb-bae6-1ba3894a5cab Tijd: Wed Aug 10 2022 10:01:00 GMT+0200 (Midden-Europese zomertijd) Serviceversie: 13.0.18800.35 Versie van client: 2208.1.12628-train URI cluster: https://wabi-west-europe-e-primary-redirect.analysis.windows.net/ Has anyone have a solution to have a Direct Query connection with MariaDb?? Thank in advance - WillemSolved860Views0likes1CommentHybrid Report Server and Service - Audit Use Case
Hi, I work in an audit community and I have some questions and was wondering if someone could point me in the right direction. We use PBI Report Server for reporting but the agency we audit has PBI cloud service. Since we are technically agency employees, we could use that too, but have not as of yet. Conceivably, we could build data marts/flow PBI Service and report from there. This would work for a lot of audit projects, since we have entrance conferences and the agency knows what we are looking at broadly anyhow. For investigative work, highly-sensitive data, or even planning work, this gets a little hairy. We obviously cannot expose this data to the agency. One great example is whistleblower data. We would never want that exposed, so that is the use case for Report Server. I am just thinking we could use datamarts for regular/recurring data that we use for broad audit projects and we could (I think) connect to Service with PBI Desktop (RS Version) and publish the report to Report Server if we did not want the report exposed to agency personnel. Am I right on this? If we were to go down this hybrid route, if we connect with PBI Desktop (RS version) to the PBI data mart/flow, what data/metadata actually gets exposed to the agency? Any help appreciated, thank you!Solved1.1KViews0likes4CommentsComposite model view access
Hi, I know there have been a lot of posts on this issue but I can't anything beyond the steps I've already taken for my specific scenario. We have a published custom calendar dataset (1), a published CRM dataset (2) and a published internal sales system dataset (3) The custom calendar dataset (1) is linked to the CRM dataset (2) to create a new dataset (4) That new dataset (4) is combined with the internal sales system dataset (3) and some measures are created in a final composite model (5) That final composite model (5) is used to create a report. That works fine in the desktop app and fine for me to view on the service. All the datasets are published to the same workspace. But another user gets the message that the visualisation can't be displayed as they don't have access to the underlying dataset. It gives them an option to request build permissions on the dataset. The user has read, reshare and build permissions for all 5 datasets (with read and reshare permissions for the actual report) Anyone have any idea what could be the issue?1.6KViews0likes5Comments