Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

PowerBI desktop issue

Hi Support

 

I have a particular user that when he clicks on refresh a shared SharePoint excel file from Power BI desktop then he got the attached errors,

 

Can you please advise?

 

Best regards

Sarmad Nazar

Need Help

3 Replies

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Anonymous does user has access to all the data source, maybe go to transform data and click refresh on each table and see which table fails to load, could be a permission issue. The first starting point to debug.

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

  • v-yingjl's avatar
    v-yingjl
    Community Support
    6 years ago

    Hi Anonymous ,

    Seems like about credentials, please try to clear permissions in data source settings (Transform data->Data soucre settings-> Clear permissions) and reconnect it to try it again.

    Or you can download the latest version of power bi desktop Jun 2020 to try to fix it.

     

    Here are some simliar issues that you can refer:

    1. Power BI Desktop - Unable to use Get Data 
    2. Error message : Cannot create process.  

     

    Best Regards,
    Yingjie Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

  • v-yingjl's avatar
    v-yingjl
    Community Support
    6 years ago

    Hi Anonymous ,

    If you've fixed the issue on your own please kindly share your solution. If the above posts help, please kindly mark it as a solution to help others find it more quickly. Thanks!


    Best Regards,
    Yingjie Li