Forum Discussion
RossChevalier
Apr 30, 2020Brass Contributor
How to update a sheet that is the data source for reports with a newer version of source data
Hey folks. This is likely a dumb question as I am trying to save repeated work. Every week, I get a SQL Server report in Excel format. It has formatting that is problematic and the column na...
SergeiBaklan
Apr 30, 2020Diamond Contributor
Not sure what do you mean exactly under dataset in PowerBI that is linked to an Excel workbook. Excel workbook is generated as SQL report.
Do you have another Excel file published on Power BI Service which query file with report? Or that's data model queries the report file? Or how it works exactly?
In general you may publish SQL report on some folder on Sharepoint online or OneDrive, power query it from another Excel file also published on sharepoint and be sure result of the query is loaded to data model. From Power BI workspace connect that file (not import) and schedule refresh. Resulting data is to be returned to Excel sheet by Pivot Table or by linkedback tables from data model.
With that updates will be more or less automatic.