Forum Discussion

analystreports's avatar
analystreports
Frequent Visitor
9 years ago
Solved

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

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

10 Replies

  • 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.

    • leJuan5150's avatar
      leJuan5150
      Helper I

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

    • dinkerson's avatar
      dinkerson
      New Member

      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's avatar
        analystreports
        Frequent Visitor

        Hi

         seems that the problem resolved by itself.

         

         

         

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
      analystreports
      Frequent Visitor

      Hi Anonymous,

       

       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's avatar
        analystreports
        Frequent Visitor

        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

  • ThiBoy's avatar
    ThiBoy
    Frequent Visitor

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

      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. 

  • I have same error since 07/Dec/2021 ðŸ¤”🤔🤔🤔