Data source error: We're sorry, an error occurred during evaluation.

[analystreports]

Hi

were facing a new problem in the web based power bi

on the data set schedule refresh

sudenly all the datasetes "get out" of the oAuth2 Authentication method (meaning they are selected on anonymous)

and when we sign in again we get that the a goog notificaion (that the dataset is connceted)

but when we reffresh the dataset , he have fuilre on

Data source type: 
Data source error: We're sorry, an error occurred during evaluation.
Cluster URI: WABI-WEST-EUROPE-redirect.analysis.windows.net

the dataset is siting in the onedrive of the user

I look here but didnt get an answer that can work

please advise on the soultion

[apoprio]

I have same error since 07/Dec/2021 🤔1 🤔1 🤔1 🤔

[ThiBoy]

Same issue here. We collect our data from an Excel file stored in Google Spreadsheet. Worked out well during the last weeks. Nothing specific changed. 

[Anonymous]

Same issues here.

With the addition of Data Source Error:  Column in Table contains blanks etc etc etc

But when I look in the PBIX file I've excluded all blanks and seems to refresh fine in Power BI Desktop. 

[mikegunns]

Hello,

I have seen these same errors as well since Friday on both our Datasets. One of the models had not been touched in weeks and had always refreshed successfully daily with scheduled refresh online. Now they both refresh fine on Desktop, but upon upload show the "Error with your dataset" icons next to them. I uploaded both the untouched-in-weeks pbix as well as another more recently updated pbix into another workspace to test as well, with the same results.

Please help ASAP as this is critical to business.

[dinkerson]

Same issue here.  An important file that had been refreshing fine for months started failing late last week.  The data set uses an Excel file located in OneDrive for Business as one of its data sources.  This is a big issue for us - please help!

[analystreports · Accepted solution]

Hi

 seems that the problem resolved by itself.

[leJuan5150]

We are experiencing the same issue except the Excel file is stored in a SharePoint Document Library as opposed to OneDrive.

[v-yuezhe-msft]

Hi @analystreports,

Do you encounter any issues when refreshing the data source in Power BI Desktop?

Also please help to describe more details about what changes you make on the data source. Moreover, I would recommend you save your Power BI Desktop file with different name, then publish it to Power BI Service and check if you can refresh the new dataset successfully.

Thanks,
Lydia Zhang

[analystreports]

Hi @v-yuezhe-msft,

 I have no problem refreshing the data in Power BI desktop ,

Im conncetig to a pbix file with "get data" from onedrive bussines ,

then I change data source credetials to oAuth2 to conncect (on the schedule refresh power bi web  )

the gateway test connect is good  

im using power bi pro

i did what you suggest but it didnt fix the issue

  *****the source of the pbix  data is in onedrive as excel file *****

please advise

[analystreports]

Hi @Lydia,

 I have no problem refreshing the data in Power BI desktop ,

Im conncetig to a pbix file with "get data" from onedrive bussines ,

then I change data source credetials to oAuth2 to conncect (on the schedule refresh power bi web  )

the gateway test connect is good  

im using power bi pro

i did what you suggest but it didnt fix the issue

 *****the source of the pbix  data is in onedrive as excel file *****

please advise