Forum Discussion
Excel Workbook content in Power BI workspace - data refresh
How do I enable data refresh in an excel workbook uploaded to Power BI workspace? The business had a simple request for a table of data with (on-prem) SQL server as the source (data gateway setup in...
Fair response. It was an ad hoc request from the business and likely not much need for visualizations outside of the singular table. At this point, I suppose I'm more interested in understanding what's possible with Excel workbook content in the Power BI workspace.
- lbendlin
Super User
Where I work we call these BMTs - business managed tables. They are used for reference data that can be manipulated by business users. These Excel files reside on SharePoint/OneDrive, and they are not linked to any other data source - they are the data source. If you import such an Excel file to a Power BI workspace you will get the synchronization for free and the data source for free.
YMMV.
