Forum Discussion

Zenna121's avatar
Zenna121
New Member
2 years ago
Solved

Prompting for account when trying to open Excel with Power BI data

Hello everyone,    I'm kind of new to PowerBI and I don't use it myself a lot. A colleague of my is working in PowerBI a lot, specifically Excel documents linked to our PowerBI enviorment.   Now...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi, Zenna121 

     

    Based on your description, every time a user works with an Excel document in a Power BI environment they will keep being prompted to log in to their account, this could be due to the following reasons:
    1. Although you mentioned configuring SSO, changes to back-end security policies or updates to Power BI or Office 365 may sometimes require re-authentication for security reasons.

    2. Credentials have changed or expired: If a user's credentials have recently changed or expired, Excel may prompt the selection of an account to refresh the access token.

    3. Power BI features require a Power BI Pro license. If the necessary license is not detected, Excel will prompt you to select the account to log in using the account with the appropriate license.

    You can try the following options to resolve this problem:
    1. Check account permissions to ensure that your colleague's account has the required permissions to access Power BI content linked from Excel.
    2. Make sure your colleague has a valid Power BI Pro license.
    3. Update both Excel and Power BI to the latest version.

     

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

Zenna121's avatar
Zenna121
New Member
2 years ago

Hi aj1973 

My colleague has both a PowerBI Pro license and edit permissions to the dataset that is linked to the Excel file.

It is not a big issue, it is more the fact that this didn't happen in 2023, so it seems like Microsoft changed something in their authentication. 

ECE's avatar
ECE
Icon for Advocate II rankAdvocate II
2 years ago

Hi,
I have the same problem also starting from Jan '24.
Previously this was never an issue. Excel would remember the credentials once provided.

This is really annoying, especially if you use VBA to update a lot of different connections.

Anonymous I have checkec everything you suggested, but this is no longer working as expected.

  • ElenaCHR's avatar
    ElenaCHR
    New Member
    2 years ago

    The same problem has disrupted all my automated processes. Please let me know if you manage to resolve it. I have one laptop and one PC. The laptop is functioning well; however, it’s my second PC that’s causing issues. Both devices are owned by the same company and are linked to just one Microsoft account.

    I have compared all the Excel settings and the business account, but I’m out of ideas.

    I think this issue started when I had to configure Microsoft Authenticator for all my devices

  • thuyeinphyo93's avatar
    thuyeinphyo93
    Regular Visitor
    2 years ago

    Finally, I found the solution to this issue. 

    The solution is we need to edit the connection string 

    • Go to Data > Properties > Definition > Connection String.
    • Change "Provider=MSOLAP.8" to "Provider=MSOLAP.7".
    • Remove "Catalog Rebound=True;" from the connection string.
      Note: It will ask for credentials only once again. Then save, close the workbook, open it back up, press refresh all