Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Data Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more

thuyeinphyo93

Refresh Power BI Semantic Model Issue with Sign-in Account

Submitted by on ‎12-11-2023 07:12 AM

i created a insert pivot table in excel from Power BI Semantic Model. The issue is it's asking for sign-in account every time when i open an excel and refresh a pivot table. Whenever i open an excel file and refresh the data, it's asking for it. Once you pick an account, it won't ask again till Excel close. 

Power BI Authentication Issue.png

Status: Investigating
See more ideas labeled with:
3 Comments (3 New)
Comments
Anonymous
Not applicable
‎12-11-2023 05:49 PM

Hi  @thuyeinphyo93 

Please check the version with your excel . You can find the info in Help . If the version is 2311 , please downgrade to 2023 and then refresh the table . 

vyetao1msft_0-1702345135918.png

If you can successfully refresh after downgrading, then it's an issue with the version of excel, then you need to contact tech support on the relevant forum. Looking forward to your reply !

Contact Us - Microsoft Support

vyetao1msft_1-1702345425801.png

 

Best Regards,
Community Support Team _ Ailsa Tao

 

thuyeinphyo93
Regular Visitor
‎05-22-2024 09:11 AM

@Anonymous Thanks a lot for your suggestion. Currently, I am using the way as you suggested. Could you please suggest any other way without downgrading the version?

thuyeinphyo93
Regular Visitor
‎09-26-2024 07:09 PM

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

Idea Statuses