Not able to refresh a table

[Anonymous]

Hello,

I have dashboard which contains 3 Dim Tables and 4 Fact Tables.  Among the fact tables, one is not refresh.  I have the following error message:

An error happened while reading data from the provider: 'Could not load file or assembly 'System.EnterpriseServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. Either a required impersonation level was not provided, or the provided impersonation level is invalid. (Exception from HRESULT: 0x80070542)'

Does someone know how to solve that issue

Regards,

[Anonymous]

Hi, you should try to run Power BI Desktop as administrator.

If it still doesn't work try to repair your .NET Framework:

https://www.microsoft.com/en-us/download/details.aspx?id=30135

Then restart

[Anonymous]

Hello,

I have open Power BI as administator and it seems to solve the issue.  Now, If I publish it on the portal, will the dataset will refresh correctly?

[Anonymous · Accepted solution]

Yes, the database should update properly. 

• Publish your project.
• Open Power BI Service (web page)
• Select your app
• go to "Datasets"
• select your dataset and click on "Schedule Refresh" 
• Switch on "Keep your data up to date"