Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Not able to refresh a table

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,

 

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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"

     

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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's avatar
        Anonymous
        Not applicable
        6 years ago

        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"