Forum Discussion

RadkaProefo's avatar
RadkaProefo
Regular Visitor
2 years ago

Analyze in excel does not save credential

Hello fellows,   I have a problem again. I have an excel file connected to power bi dataset. This file is saved in sharepoint.   Then this file is synchronized to server. There is a trigger in sc...
Data Protection
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi RadkaProefo

 

Based on the information you provided, you can try the following to troubleshoot the problem.

 

  • Check to see if the file has stored credentials in the location shown here.

 

  • updated versions of Power Bi and Office
  • Re-establish the connection between excel file and Power Bi. Before doing this, if necessary, please backup the history of the connection to avoid it being overwritten by the new connection.

If I've misunderstood you, please provide more detailed information. So that I can help you better. Show it as a screenshot or excel. Please remove any sensitive data in advance.

 

Best Regards,
Community Support Team _Yuliax
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

RadkaProefo's avatar
RadkaProefo
Regular Visitor
2 years ago

Hi Support,

thank you for answer, but the connections are not in Power BI, it is in Excel. It is connected to Power BI service to a dataset.

 

The credentials used to be saved. But now the Excel askes for account to connect every time I open it.

Excel is quite updated, I will ask our provider to update it again.

Re-establishment did not help.

 

Best regards,

Radka Jánská