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 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI bensm,

Have you successfully install the .net framework environment on your device who installed the gateway client? I'd like to suggest you to use the following tools to check and your software environment:

Microsoft .NET Framework Repair Tool is available 

In addition, any particular R package that invoked in your R scripts? AFAIK, power bi service will block some third-party package and some operation due to security reasons:
Create visuals by using R packages in the Power BI service 

Power BI Security#data-storage-security 

Regards,

Xiaoxin Sheng

bensm's avatar
bensm
Frequent Visitor
6 years ago

Thanks for the reply, but unfortunately it still gave the same error. It is definitely linked to an R authentication error. I have found a solution to bypass it, by running R through windows task scheduler through a .bat file and importing that flat file into Power Bi. 

 

If there is an alternative solution to the .Net error, I'd happily try that.