Monitoring by system center - deployed instances - how to relate the error to the item specified
Our infrastructure department uses system center to monitor our powerbi report server. One of the notification categories is "All deployment instances are discovered". This category checks whether the reports are runnable given the datasource credentials entered on the report server. Within the notificatons returned it is not easily traceable which report has the culprit so we have to start a search manually by investigating each report manually. We receive a guid like ID from system center which should relate to the affected item like 7EB2A3ED-9DC4-42C5-9AE8-0D754AE909C6:KLFC005399\PBIRS But the guid (7EB2A3ED-9DC4-42C5-9AE8-0D754AE909C6) itself does not lead to any item when we let a procedure check the total database with this guid The datasource table within report server is encrypted, this could have been a good source to investigate but as being descripted it is not usable. I was wondering how you solve these errors easilyGateway 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?
Data source from one drive in on-prem report server
Hi All I have some data source that is connected to our organisational one drive (excel). In order to do a scheduled refresh, I'm required to input the credentials but organisation authenication is not available under the authentication type. Tried anonymous and windows authenication, the error shows: "The report server couldn't connect to the data source using the information you entered. Make sure you've entered the connection string and any credentials correctly."
Adding a header to a web API request in the data sources section of a report in PBI Report Server
Hello everyone, I have created a report using power bi desktop (Vesrion January 2021). In order to get the data for this report, I connect to a web API using the provided API key in the header part of the request: This part works fine and I get the necessary data to work on the Power BI desktop. When I publish the created report to a Power BI Report Server, as you can see in the following image, there is no way to add the header data which in this case is mandatory to authenticate: The Authentication part in the Credential section in the above image does not support adding headers data and only accepts Anonymous, Basic, and Windows authentication which are not applicable here (The test fails). As the data in my report changes regularly and I need to schedule an automatic refresh, the Report Server has to connect to the Web API at the scheduled times in order to get the latest version of the data. I would appreciate it if you could help me to solve the encountered problem. Regards
Problem with data source settings after changing the password
Hello! I have some problem with data source after changing my credentials. This problem is on screenshot below. I can't change anything here and I don't know what to do. Maybe someone have encountered such problem and can help with advice. Thank you in advance!Power BI server Sharepoint Credentials don't recognize
Hello guys, I need your help, I made a Power BI report using data from a Sharepoint Folder (the report combine all the Excel files in the Folder). I set the credentials of my Organization and it works perfectly in Power BI desktop. The problem comes when I published the report in the server. I tried to set the scheduled refresh, unfortunately it shows me this message: I have been looking for help in the forums and in the page of support from Windows (https://docs.microsoft.com/en-us/power-bi/service-admin-troubleshooting-power-bi-personal-gateway). Since the Sharepoint is in cloud I do not need to set a Gateway connection. When I tried to updated the credentials this message appears me: Do you have any idea why the server is not recognizing my credentials and why when I tried to updated them an error occurs?
