Forum Discussion
Issues refreshing from Excel Workbook OneDrive for Business
Hello!
No, originally, I published my Desktop report to Service.
Since my source/dataset is Excel on OneDrive for business, a connection was established and I didn't need to apply a gateway.
And since I now have the report on Service, where the dataset is Excel on OneDrive (which the connection established), I thought the correct way now to update the data in both Service report and Desktop report would be to refresh dataset and report.
How I am doing that is simply by adding the new rows of data for last month in my excel sheet
/
Sebastian
And just to clarify:
I am not interested in (and I am aware of) that the report on service is now its own report. I am not looking for changes in the service report regarding changes in vizualisations, or measures, or columns made in desktop.
the only thing I am interested in is to be able to have Excel in OneDrive for business as my source/dataset for Desktop and for Service. As of now, none of them refreshes the correct data (no data at all) even though a connection is established.
Best regards/
Sebastian
Anonymous,
In Query Editor of Power BI Desktop, click Refresh Preview and check if new rows are added to the imported table.
In Power BI Service, check refresh history to see if there are any error message.
Regards,
LydiaAnonymous
I've done both of those things
In desktop, no rows are added
In Service, no rows are added although refresh has been done and refresh history has correct datetime for latest refreshes
This is a problem I can't get my head around
//Sebastian
Anonymous,
It is strange. Could you please connect to the Excel in a new PBIX file, and check if the new rows of the Excel file appear in PBIX file?
Also you can share me the Excel file, I will test it in my Desktop.
Regards,
Lydia