Forum Discussion

Frequent Visitor

9 years ago

Analyze in Excel: Change log in credentials

Is there a way to change your log in credentials in Excel once you have authenticated for the first time? I would like to analyze the data with several users that have different roles in Power BI, bu...

Need Help

adri_s

Frequent Visitor

9 years ago

Hi v-qiuyu-msft,

Yes, that is exactly what I am looking for. Thanks for the answer.

If anyone has the same problem, I found a work-around. Just upload any pbix file to Power BI, download its ODC and remove the dataset. After that, open this ODC file (the workbook with the ODC connection to the real file you want to analyze must be closed) and you will be prompted to enter your credentials. Cancel and close the book, then open the workbook with the real data and you will be asked for your credentials once again, so you will be able to change to another user.

However, there should be an actual way to log out and change the user.