cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kcantor
Community Champion
Community Champion

Repeated refresh failure

I am having major issues today with refresh. My reports are failing due to credentials but the credentials are not the issue. Here is the error message I am getting:

Failed to update data source credentials: Failed to connect to a database. Error message: Could not load file or assembly 'Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.Hide details

Activity ID:3637c659-f00a-44a1-9b30-9781fe00afeb
Request ID:4637372d-463c-ab59-dd8a-9dd3c29c90ef
Status code:400
Time:Thu Apr 28 2016 14:34:17 GMT-0400 (Eastern Standard Time)
Version:13.0.1100.466
Cluster URI:https://wabi-us-north-central-redirect.analysis.windows.net
Details:Failed to connect to a database. Error message: Could not load file or assembly 'Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.

 

I have filed a ticket but am hoping that someone here can offer faster assistance.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




1 ACCEPTED SOLUTION

and BOOM, just like that . . . I fixed it. It was the gateway. I uninstalled, reinstalled, and revalidated my credentials. Now it is working.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

11 REPLIES 11
Greg_Deckler
Super User
Super User

What is the data source?


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Both sources fail independently. One is an excel file table (DimDate) and the other is sql server database.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




May not matter, but personal or enterprise gateway? Is Excel file on-premises in a folder or OneDrive? SQL Server on-premises?

 

Sorry, want to see if I can recreate exactly.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Sorry, I should have provided more details. The excel file is in one drive. The sql server database is on premise. The refresh failure is occuring within a group. I can, obviously, refresh the dataset through the desktop and upload that to the group files area. The failure sites invalid credentials but they are windows credentials and . . .  well I am logged in and working.

And, forgot to add, personal gateway.

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




OK, I imported and connect to an Excel file on OneDrive for Business and was able to refresh them. Not sure if that exactly mimics your scenario or helps you in any way whatsoever.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

I am still gettting a failure. I even replaced the source file on the dataset and it refuses to refresh. It is cascading through other data sets now.

Filed a ticket. Hopeing for help.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




kcantor
Community Champion
Community Champion

@Sandy and @Greg_Deckler this started after I updated the gateway. Could the gateway be causing this?

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




@kcantor - That's certainly a possibility. Then again, I'm not sure the gateway comes into play with OneDrive files.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

and BOOM, just like that . . . I fixed it. It was the gateway. I uninstalled, reinstalled, and revalidated my credentials. Now it is working.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Glad you got it fixed, so you reinstalled the same version of the gateway or the previous version?


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Oddly enough, I reinstalled the exact same version. Not sure what exactly happened but it must have had a misstep in the update/install.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors
Top Kudoed Authors