Forum Discussion

albertoserinf's avatar
albertoserinf
Regular Visitor
8 years ago
Solved

Scheduled refresh failed : There was an error when processing the data in the dataset.

When trying to update dataset in Power BI service by using the scheduled data refresh via the gateway I got this error message

 

 

 

The pbix file has been created with Power BI Desktop and the datasource is an on-premise SQL server database.

 

Thanks for your hints.

 

Regards

 

Alberto

Need Help
  • albertoserinf's avatar
    albertoserinf
    8 years ago

    Anonymous

     

    We solved this issue by creating a view of the table within the source database

    Thanks for your hints.

    Regards

     

    Alberto

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    albertoserinf,

    The above error message points to Pick_fact_revenues table. Are you able to refresh the data when you open report in Power BI Desktop? And have you checked if there are any issues with Pick_fact_revenues  table in Power BI Desktop?

    Regards,
    Lydia

    • albertoserinf's avatar
      albertoserinf
      Regular Visitor
      8 years ago

      Good morning Lydia

      Yes, we are able to refresh data within Power BI Desktop.

      We found out that the problem is linked to the size of the Pick_fact_reveneus table within the SQL database we connected to the datamodel.

      Since this table is bigger than 10GB,  the uncompressed data received by the data gateway client exceeds the limit admitted for Power BI Pro.

      Now my question is:

      let's say that we find out a way within Power BI Desktop to reduce the amount of data we import from this table, but the size of this table reamains the same in the source database (bigger than 10GB).

      What happens when we try to schedule a data refresh by using the data gateway? Does this limit still exist? 

      Thanks Anonymous for your reply.

        

      Regards

       

      Alberto

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        albertoserinf,

        What is the size of your PBIX file? The maximum size for datasets imported into the Power BI service is 1 GB and Power BI Service places a limit on the amount of uncompressed data that is processed during refresh to 10 GB.

        If you still hit the above two limitations, you are not able to refresh dataset in Power BI Service. You can use DirectQuery/Live connection mode to connect to your data source instead, or purchase Power BI Premium license to solve this issue.

        Regards,
        Lydia