Tabels connection
Hi All, I have two tabels connected with one to many connection, column "Reference" from table "postingline" connected to column "TR_gl_ref" from the "TR hist" table (reference is the one, tr_gl_ref is the many). When im putting the two toghter on table visual it seems fine (pic below. table B): than im building another table visual which contain the "Reference" column (pic below,table A) Now, im clicking on a specific cell at the reference column at table A (IC241210000974) and table B data is disaapearing (pic below): I dont understand why its disappearing and not showing me filtered date according to my choice at table A. Please help 🙂
Infor ERP XML files Connecting to Power BI Reporting (currently use INFOR Plug-In to SSRS)
Current situation that we have in Infor ERP system ,user rendered SSRS report in HTML, PDF or XLS formats and see it as it would be pure Microsoft . Behind the scenes, output Infor ERP XML files (!) connect between SSRS report dataset to Infor ERP LN reports, with help of Infor ERP provided Plug-in. We need to smoot migration to Power BI Paginated Reports with old SSRS reports. As we understand SSRS report design file (.rdl) can be used in Power BI, with minor changed. We are looking forward for connector Infor ERP XML files to Power BI . Can some please recommend us, if there is any connector or third party tool which can help us.Problem with GA4 2.0 connection
Some time ago I connected to GA4 using the Google Analytics 2.0 connector, however, in December it started to present the problem below, and no changes were made to it during the period. What makes it seem even stranger is that in the automatic update, some days it updates, and other days it presents the same problem without making any type of adjustment. Please, can anyone help? Problem presented: DataFormat.Error: We found an unexpected character in the JSON input.DetailsReason = DataFormat.Error Value = \31 Position = 0 In the advanced editor it looks like this: let Fonte = GoogleAnalytics.Accounts([Implementation = "2.0"]), #"navegation1" = Fonte{[Id="accounts/9999999"]}[Data], #"navegation2" = #"navegation1"{[Id="properties/9999999"]}[Data], #"navegation3" = #"navegation2"{[Id="properties/9999999"]}[Data], #"Itens Adicionados" = Cube.Transform(#"navegation3", { {Cube.AddAndExpandDimensionColumn, "transactionId", {"transactionId"}, {"transactionId"}}, {Cube.AddAndExpandDimensionColumn, "date", {"date"}, {"date"}}, {Cube.AddAndExpandDimensionColumn, "campaignName", {"campaignName"}, {"campaignName"}}, {Cube.AddAndExpandDimensionColumn, "medium", {"medium"}, {"medium"}}, {Cube.AddAndExpandDimensionColumn, "source", {"source"}, {"source"}}, {Cube.AddMeasureColumn, "totalRevenue", "totalRevenue"} }) in #"Itens Adicionados" * The IDs have been changed to "9999999". I'm warning you so it doesn't look like it's a mistake.
DAX and Tables used in DAX/Measures creation - dependent and precedent
Just curious to know if there is any option from which we can easily identify the columns, tables or any existing measures has been used in new measure creation. something similar to Trace dependent and precedent in excel. Natalie_iTalentReport builder connection to Access will not work once published
I built a paginated report that has an MS Access database as its source. When I publish the report I cannot acccess it. I get the following error: Unable to render paginated report There was an error contacting an underlying data source. Manage your credentials or gateway settings on the management page. Please verify that the data source is available, your credentials are correct and that your gateway settings are valid. Timestamp: 2023-05-10T10:36:55.812Z Root activity ID: fc2227fa-c74d-8a31-3114-8b5d28415c8c Session ID: 0000918024c24e01ad3df76a4cf95d2a Tenant ID: 78cfdb8f-c5d8-447a-bd00-4a88beced94a Cluster: https://wabi-us-north-central-g-primary-redirect.analysis.windows.net/ Report ID: d719889b-76b3-4372-8959-2166384855a5 ReportViewerVersion: 2023.5.1.704 What is the best way to connect to an Access database?Gateway invalid Credentials
Hello to everyone, It has been 2 weeks now that i get the following error and i did not make any changes (the scheduled refresh was working 2 months in a row). Data source error: {"error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","pbi.error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The credentials provided for the File source are invalid. (Source at \\\\eu962114-ger\\ger_data$\\pbi-logistics newdev\\frr forecast\\fnrforecastaccuracy.xlsx.)"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourceKind","detail":{"type":1,"value":"File"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourcePath","detail":{"type":1,"value":"\\\\eu962114-ger\\GER_Data$\\PBI-Logistics NewDev\\FrR Forecast\\FnRForecastAccuracy.xlsx"}},{"code":"Microsoft.Data.Mashup.CredentialError.Reason","detail":{"type":1,"value":"AccessUnauthorized"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"File\",\"path\":\"\\\\\\\\eu962114-ger\\\\GER_Data$\\\\PBI-Logistics NewDev\\\\FrR Forecast\\\\FnRForecastAccuracy.xlsx\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"AccessUnauthorized"}}],"exceptionCulprit":1}}} Table: 99Results. Cluster URI: WABI-NORTH-EUROPE-K-PRIMARY-redirect.analysis.windows.net Activity ID: f71198f8-4cae-4ad6-aee8-b2fc06362623 Request ID: 259fd469-1cf3-afa6-ce77-b54aa5c67717 Time: 2023-03-22 12:35:40Z Could help me find a solution?
On-premise Power BI Report Server to On-premise SAP HANA SSO / SAML connection
Dears, we have an On-premise Power BI Report Server and On-premise SAP HANA. Would anyone guide to establish a connection with proper SSO / SAML configuration ? Kindly note: we have searched already and most of the links lead to Power BI cloud / service which is not our scenario. Thank you in advance.
