Forum Discussion
Live connection asks for credentials each time
As of a few days, every time you refresh a live connection in excel, it asks for credentials. Anyone knows why that is the case?
I can't reproduce your question, can you provide more detailed information? For example, where is the excel file you are referring to? Can you provide a screenshot of the "asks for credentials" screen?
Please remove any sensitive data in advance.
Best Regards,
Yulia Xu
Hi Anonymous ,
When you create a live connection table from Power BI service to excel, by right clicking on the corner of a table in a repor and selecting export data -->Summarized data-->file format xlsx with live (500k row) connection.
Once you have that file, it loads the table in excel in your desktop and it asks for credentials. All good until here. The issue is that now, every time you open the file and refresh it asks for credentials.