Forum Discussion
croma
Advocate II
Advocate IIGet data from Excel workbook files
Struggling to understand documentation when reading: "If your workbook has simple worksheets with ranges of data, to get the most out of your data in Power BI, be sure to format those ranges as t...
GilbertQ
Super User
Super UserHi there
If I understand correctly whilst you can connect to Excel workbooks with tables, you cannot refresh or edit another Excel workbook that is connected to the data.
The best thing is to import the data into PBI as another source.
If I understand correctly whilst you can connect to Excel workbooks with tables, you cannot refresh or edit another Excel workbook that is connected to the data.
The best thing is to import the data into PBI as another source.
cromaThank you GilbertQ for your attention
problem is not about refreshing but about results importing onedrive excel workbook as PBI data source.
(GetData --> Files --> OneDrive BUSINESS --> (Connect) --> Import)
If Workbook source has only excel tables (built from a range + CTL+t with standard blue formatting) I get them in service data source.
If Workbook has both "simple" excel table as above and any data inside Power Pivot Data Model then in service data source I get only PPDM data
Could you help me understand if this is by design (I hope not) or if I'm doing something wrong?
(Either case documentation is misleading imho)