J N on 24 May 2024 16:00:32
Currently linking to an Excel file on OneDrive using the new Excel connector in Power BI Service and wanting to add a new column to my worksheet. I add the column, ensure the file is sync'd to the OneDrive cloud and the refresh the semantic model in Power BI Service. The new column does not appear.
To add the new column, i must download the semantic model as a PBIX file, open in PBI Desktop; refresh the model and the column appears. I then must upload the PBIX file back to the workspace.
Would like linking to Excel file through PBI Service to refresh the table/columns that are there and any new columns that may have been added, or even worksheets, so it behaves like PBI Desktop.
Many of our citizen report developers will default to Excel/CSV connector as a source for their visuals. This feature would support broader use of the product.
Thanks!