Forum Discussion

bensm's avatar
bensm
Frequent Visitor
6 years ago
Solved

ADO.Net: Failed to find or load the registered .Net Framework Data Provider

Hi,   I've been struggling with this for a while if someone could perhaps help me out. We transferred our subscription service, and I got new BI credentials. I changed my gateway credentials and fi...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi,

     

    Please check the following solution (works for me, it turned out that they forgot to put the Microsoft.PowerBI.Scripting.dll in the m folder):

     

    1. Go to the app folder (for me: D:\Program Files\On-premises data gateway (personal mode) ) and copy the Microsoft.PowerBI.Scripting.dll file into 'm' folder (D:\Program Files\On-premises data gateway (personal mode)\m )

     

    2. Kill all the gateway processes (especially Microsoft.PowerBI.DataMovement.PersonalGateway.exe)

     

    3. Run the gateway and check the results 

frank_pong's avatar
frank_pong
Frequent Visitor
6 years ago

Hi,

 

I have the same issue with credential with R on the Power BI Service. I am able to refresh my report using Power BI Desktop, but it would give me the same error message as the ones the original poster posted.

 

This starts after I had to update the On-Premises data gateway (personal mode) to 3000.40.15 (May 2020). I am not sure if this is the issue, but I updated the personal gateway on the 24th, and the next scheduled reports with R Script have all failed.

 

The R script I used is simply to output the dataset into a "csv" file.

 

currentDate <- Sys.Date()

csvFileName <- paste("c:\\doc\\Output_",currentDate,".csv",sep="")

write.csv(dataset, file=csvFileName)

 

please let me know how I can go about this issue,

 

Thank you,

 

Frank