Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
I have same error since 07/Dec/2021 🤔1 🤔1 🤔1 🤔
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.
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.
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.
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!
Hi
seems that the problem resolved by itself.
We are experiencing the same issue except the Excel file is stored in a SharePoint Document Library as opposed to OneDrive.
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.