Forum Discussion

adri_s's avatar
adri_s
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
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi adri_s,

 

Based on my understanding, when you use Analyze in Excel to download .ODC file and open it in Excel, you will enter the Power BI Service account. And then you want to change this Power BI service account within this .ODC file, right?

 

Based on my test, once we authenticate the Power BI when we open the .ODC, the data connection will use this authenticated user to connect to Power BI. And there is no OOTB properties for us to change authenticated user. For your requirement, it can't be achieved currently.

 

Best Regards,
Qiuyun Yu

adri_s's avatar
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.

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    9 years ago

    Hi adri_s,

     

    Thanks for sharing the work around. :smileyhappy:

     

    For your requirement, you can post a feedback in Ideas Forum.

     

    Best Regards,
    Qiuyun Yu