Forum Discussion
Issues refreshing from Excel Workbook OneDrive for Business
Hello, I have a problem, and found solutions that doesn't fit my problem.
Scenario:
1. Datasource is Excel Workbook (sheet, not table) that I store in my OneDrive for Business.
2. pbix-file on my computer has the Excel Workbook (1.) as datasource
3. PBI service report has Excel Workbook (1.) as dataset
4. I have followed all steps with the "web part" when connecting data via Excel from OneDrive for Business, and taken away "=web?", authenitcation method to OAuth2 settings and so on.
5. In PBI-service I even get postive response when I refresh, saying a refresh has been completed from my Excel Workbook from OneDrive for Business.
However... Niether my local pbix file and report on Service actually does the refresh - my data is all the same still, even when refresh has been done. I do not understand what is wrong.
I also noted that under "edit credentials" under Settings in Datasets, I sometime needs to reset it, since it goes back to Anonymous from my OAuth2.
What to do?
//Sebastian