Forum Discussion

keitoledo's avatar
keitoledo
Regular Visitor
9 months ago
Solved

Scheduled Refresh Failure

Hi,   I just want to ask if you've experienced this kind of error message and how did you troubleshoot it? Thank you.   Failure details: The last refresh attempt failed because of an internal ser...
Need Help
  • grazitti_sapna's avatar
    grazitti_sapna
    9 months ago

    Hi keitoledo 

     

    Please try these troubleshooting steps and and let us know if it works:

    1. Configure a workspace identity for the Power BI workspace:
      • Go to the workspace settings in the Power BI service.
      • Navigate to the "Workspace Identity" section.
      • Create and enable a workspace identity if one does not exist.
    2. Ensure the model owner has Contributor or higher access to the workspace:
      • Verify the access permissions of the user who owns the dataset/model.
      • Grant Contributor or higher role in the workspace if needed.
    3. Alternatively, change the data connection authentication method:
      • Edit credentials for the data source in the dataset settings.
      • Use a different authentication method instead of workspace identity if appropriate.
    4. After making these changes, republish the dataset if required and trigger the refresh again.

     

    🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.

    💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.

    🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.

    🔗 Curious to explore more? [Discover here].

    Let’s keep building smarter solutions together!

grazitti_sapna's avatar
grazitti_sapna
Super User
9 months ago

Hi keitoledo 

 

Please try these troubleshooting steps and and let us know if it works:

  1. Configure a workspace identity for the Power BI workspace:
    • Go to the workspace settings in the Power BI service.
    • Navigate to the "Workspace Identity" section.
    • Create and enable a workspace identity if one does not exist.
  2. Ensure the model owner has Contributor or higher access to the workspace:
    • Verify the access permissions of the user who owns the dataset/model.
    • Grant Contributor or higher role in the workspace if needed.
  3. Alternatively, change the data connection authentication method:
    • Edit credentials for the data source in the dataset settings.
    • Use a different authentication method instead of workspace identity if appropriate.
  4. After making these changes, republish the dataset if required and trigger the refresh again.

 

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.

💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.

🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.

🔗 Curious to explore more? [Discover here].

Let’s keep building smarter solutions together!