Forum Discussion

itpamp's avatar
itpamp
Frequent Visitor
4 years ago
Solved

Dataset won't refresh

Hello,   I have created a new Power BI Dataset (using an existing Excel file from OneDrive Business) and it suddenly stopped refreshing.   This is the error I'm getting:     Thanks in ad...
Need Help
  • itpamp's avatar
    itpamp
    4 years ago

    I deleted the Dataset, uploaded again the Excel file and build the flow and Power BI file from scratch, now it's working properly.

parry2k's avatar
parry2k
Super User
4 years ago

itpamp maybe there is an issue with the excel file or the structure is changed. easier would be to open pbix in desktop, run refresh and see if it still works, you will get better error details on the desktop.

 

✨ Follow us on LinkedIn

 

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to 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.⚡

  • itpamp's avatar
    itpamp
    Frequent Visitor
    4 years ago

    Thanks for your reply!

     

    I have tried to refresh from desktop app but sadly the result is the same.

    I know a workaround is to delete the Excel file, upload it again and renew the Dataset, but I'm trying to avoid this approach because it would force me to rebuild a good portion of my Power BI report.

     

    Maybe I'm overlooking something?