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.Costa Rica Bootcamp 2023 - Power BI
Es un evento que contará con la presencia de experimentad@s confencistas que presentarán desde temas introductorios a Power BI, hasta temas más avanzados sobre el uso de la herramienta e integración en los entornos de trabajo. Sé parte de la experiencia a nivel mundial llamado "Experience Global Power Platform Bootcamp 2023" participando desde la comunidad. Tendremos una mañana de 4 sesiones, conocimiento, talento, oportunidad para preguntar a los expertos y café Inscripción: https://www.eventbrite.com/e/492790939967 Cupos limitados. 25 de febrero con horario de 8:00 a.m. - 1:00 p.m.
Issue Opening Power BI Report from Sharepoint
Good Afternoon, Power BI newbie here. I'm getting a connection issue trying to open a Power BI Report from Sharepoint. Any idea what the issue could be? Two of my reports open just fine, but one is giving me the attached error. Any assistance would be greatly appreciated. Thanks.Sharepoint List: Visualize The List - Something went wrong
Hi, Has anyone come across below error message and how they remedied it? Basically I'm trying to use the "Visualized The List" feature in Sharepoint and whenever I do it I get a message that says "Something went wrong"... Any idea on how to fix this? Something went wrong We're having trouble visualizing your SharePoint list data right now. Please try again later or contact support. If you contact support, please provide these details Activity ID: ab038106-d380-45db-8cb8-6d4e1c9cf2a5 Request ID: dd7cbb2b-dfc0-94fb-e72e-a1331f6089b2 Correlation ID: 6ab903df-f837-acad-d6cf-3ba370b4b92f Status code: 400 Time: Thu Jun 13 2024 08:34:35 GMT-0400 (Eastern Daylight Time) Service version: 13.0.23465.65 Client version: 2406.1.19574-train Cluster URI: https://wabi-canada-central-redirect.analysis.windows.net/
Organizational account credentials from Power BI Server?
Hi, I've created a report with a Sharepoint Folder data source (specificaly, an excel xlsx file in a folder of my Sharepoint site). My Sharepoint is hosted on Sharepint Online and I access it via Organizational Credentials. I've been able to do it in Power BI Desktop for Report Server (October 2017). Once I publish my report to POwer BI Server, I go to "Manage > Data Source" , there in Credentials I can only choose Anoymous or WIndows Authentication. Is there a way to have a report pulling data from Sharepoint Online from Power BI Server as of now? (and have it refresh on a scheduled basis). THe idea is to have some select users edit data in the EXcel file, and management can open the report done in POwerBI. (I'd like to avoid having to open the report in PowerBI Desktop and republish it everytime there is a change in the data source, which is what I am doing for now.)
exporting and importing sharepoint sites
Good morning everyone! I've set up a SharePoint site with various security groups, flows, forms, and PowerApps linked together to collaborate. What I'd like to achieve is the ability to export this setup and import it into another environment. I've noticed that through Power Admin, flows and PowerApps can be saved. However, SharePoint sites cannot be saved using this method. I've read online that this might be achievable with PowerShell using the Export-SPWeb command. However, I'm not entirely clear on the exact steps to follow. Does anyone have experience with exporting and importing SharePoint sites? Could you please provide a step-by-step guide on how to do this? If there's an alternative method other than the command mentioned above, I'd also appreciate hearing about it. Thank you in advance!
fail to connect sharepoint Data source in power bi report server
Hi everyone: I select sharepoint folder as datasource when i make report in power bi desktop. I can refresh it in the power bi desktop.After i upload the report on the report server. I try to connect the datasource and schedule refresh.Authentication Type has two options,anonymous and window authentication. So i think it is sharepoint on premises.Because if it is sharepoint online.it shouldn't have these options.However, unexpected error encountered when i choose the two options. I use my corporate domain and username when the authentication is windows authentication. The same error .Log on failed. Ensure the user name and password are correct. I wish you can help me to solve this issue. You can save my life!
