locked
Power Pivot Refresh issue RRS feed

  • Question

  • Hi Everyone,

    I have a Power pivot report connects to SQL Cube, when i refresh the Pivot it is working fine for me, however user is getting credentials prompt when they try to refresh.

    They have access to cube to refresh from pivot.

    Could you please help me on this.

    Thanks,

    Kishor

    Friday, August 18, 2017 7:52 AM

Answers

  • Hi Kishor,

    Thanks for your question.

    In this scenario, you may need to tick the Save password option for your connection string.

    To do this, please go to Excel menu Data, Go to "Connections---Properties---Definition" ,please check the option "Always use connection file" and "Save password". Please refer to below image:


    Best Regards
    Willson Yuan
    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com


    Friday, August 18, 2017 8:11 AM