Erro de credenciais ao conectar Power BI a arquivo Excel no SharePoint
a { text-decoration: none; color: #464feb; } tr th, tr td { border: 1px solid #e6e6e6; } tr th { background-color: #f5f5f5; } Olá, pessoal. Estou enfrentando um problema ao tentar criar uma nova conexão no Power BI com um arquivo Excel armazenado em uma pasta do SharePoint. O processo que estou utilizando é o seguinte: Acesso o arquivo no SharePoint; Clico nos três pontos (...) > Detalhes; Vou até o final do painel de detalhes e copio o caminho do arquivo; Abro o Power BI Desktop; Seleciono Obter Dados > Web; Insiro o link/caminho copiado do SharePoint. Porém, ao tentar realizar a conexão, o Power BI informa que as credenciais são inválidas. O estranho é que eu tenho acesso normalmente tanto à pasta no SharePoint quanto ao próprio arquivo. Inclusive, consigo navegar até o arquivo pelo SharePoint para copiar o caminho mencionado acima. Esse problema está impedindo que eu crie novas conexões diretamente com arquivos do SharePoint e, consequentemente, configure a atualização automática dos dashboards no Power BI Service. Um detalhe importante: arquivos que já estavam conectados anteriormente continuam sendo atualizados normalmente no Power BI Desktop. O problema acontece principalmente ao tentar criar uma nova conexão. Também estou tendo problemas para atualizar essas conexões diretamente pelo Power BI Service (app.powerbi.com). Eu já havia enfrentado esse mesmo problema anteriormente. Por algum tempo ele simplesmente deixou de ocorrer, mas agora voltou. Alguém já passou por esse comportamento? Existe alguma solução definitiva para o erro de credenciais inválidas ao conectar arquivos do SharePoint ao Power BI? Também gostaria de saber se existe alguma configuração de autenticação, permissão, cache de credenciais ou método de conexão mais recomendado para arquivos Excel armazenados no SharePoint. Qualquer orientação será muito bem-vinda. ______________________________________________________________________________________________ a { text-decoration: none; color: #464feb; } tr th, tr td { border: 1px solid #e6e6e6; } tr th { background-color: #f5f5f5; } Hi everyone, I'm experiencing an issue when trying to create a new connection in Power BI to an Excel file stored in a SharePoint folder. The process I'm currently using is: I navigate to the file in SharePoint; Click (...) > Details; Scroll to the bottom of the details pane and copy the file path; Open Power BI Desktop; Select Get Data > Web; Paste the SharePoint file URL/path. However, when I try to establish the connection, Power BI reports that the credentials are invalid. The strange part is that I have access to both the SharePoint folder and the Excel file itself. In fact, I can navigate to the file normally in SharePoint to copy its path. This issue prevents me from creating new connections directly to files stored in SharePoint and, consequently, from configuring scheduled refreshes for my dashboards in Power BI Service. One important detail is that files that were already connected previously can still be refreshed normally in Power BI Desktop. The issue mainly occurs when I try to create a new connection. I'm also having problems refreshing these connections directly through Power BI Service (app.powerbi.com). I experienced this same issue before. At some point, it stopped happening without any apparent change on my side, but now the problem has returned. Has anyone experienced this behavior before? Is there a definitive solution for the "invalid credentials" error when connecting Power BI to Excel files stored in SharePoint? I'm also wondering whether there is a recommended authentication method, permission setting, credential cache configuration, or a better connection method for Excel files stored in SharePoint. Any advice would be greatly appreciated.
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
PostgreSQL- Publish Error
I'm having an issue around published dashboard that connect to PostgreSQL that do not work. From my Power BI desktop, I can connect to PostgreSQL and build a (direct query) viz with no issues. I can even publish and get the "success" window. However, when I go to view the published dashboard, I get an access error about credentials. I have not modified anything on the PostgreSQL/ AWS side, but I'm wondering if there is something outside of Power BI that needs to be modified (maybe ralated to SSL)? Thank you. Thank you in advancedProblem 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!
