Forum Discussion

genesisvega's avatar
genesisvega
New Member
1 year ago
Solved

Query Evaluation failed

Hi everyone I am getting the message "Query Evaluation failed for query: Rep20C".  In Power Query, the refresh worked without problems. Here is the whole report if anyone can help:     Feed...
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

    I would change the data sources to CSV or Parquet, and put the CSV files on a SharePoint.  Embarrassingly the Power BI SharePoint folder connector does not support larger Parquet files.

genesisvega's avatar
genesisvega
New Member
1 year ago

The query table is roughly around 3 million 😞 it does load in power query but in the report it does not

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

There are different timeout limits on the desktop and in the service.

 

What is the data source?

  • genesisvega's avatar
    genesisvega
    New Member
    1 year ago

    There are multiple sources that feed the pbi: 

    if its a timeout issue, would it be best to move the report somewhere else?

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      1 year ago

      I would change the data sources to CSV or Parquet, and put the CSV files on a SharePoint.  Embarrassingly the Power BI SharePoint folder connector does not support larger Parquet files.

      • v-menakakota's avatar
        v-menakakota
        Icon for Community Support rankCommunity Support
        1 year ago

         

        Hi genesisvega ,

        Thank you lbendlin  for providing the valid point.
        Please follow the below steps:

        • Apply filters in Power Query to limit the number of rows loading into the report.
        •  Ensure that Power Query is pushing transformations back to the data source to improve performance.