Forum Discussion

Claster's avatar
Claster
Advocate II
8 years ago
Solved

Error when refresh data from PowerBI service

Hello, I have an error whe my model is refresh from PowerBI service, but whe i refresh model from power bi desktop I don't get error.
Need Help
  • Claster's avatar
    Claster
    8 years ago

    I found the reason, in some rows of the table there were dates 0001-01-01T00: 00: 00 I replaced them with null and model refreshed without error

Claster's avatar
Claster
Advocate II
8 years ago

I have Odata connection string and only one data source

Claster's avatar
Claster
Advocate II
8 years ago

Any ideas? My model don't refresh :( 

  • zoloturu's avatar
    zoloturu
    Memorable Member
    8 years ago

    Hi Claster,

     

    1. Do you use Import mode?

    2. How big is your PBIX file if you save this report on PC?

    3. Are you Power BI Pro user?

    4. Do you have Power BI Premium/Embedded capacity?

    • Claster's avatar
      Claster
      Advocate II
      8 years ago

      1. No

      2. 14 Mb

      3. Yes

      4. No

       

      My model stop refresh since 27 May.

      • zoloturu's avatar
        zoloturu
        Memorable Member
        8 years ago

        Claster,

         

        Can you double check if you didn't cut part of the error message (see blue)? Is it full what you saw?

         

         

         

         

         

         

         

        And to exclude memory issue. Can you go to Task Manager -> Resource Monitor (or press Win + r then paste perfmon.exe /res and press OK) 

        *See other ways to run it - https://www.isunshare.com/windows-10/7-ways-to-access-resource-monitor-in-windows-10.html

         

        Go to Memory tab, find all process with name msmdsrv.exe and click on each. 

        Start you refresh in PBI Desktop and tell maximum values for Commit (KB) and Working Set (KB) until the end of a refresh.

        resource monitor