In the Source Table column, sheet names are suffixed with a “$” whereas named ranges are not.ħ. Browse to the Excel file and tick “Use first for as column headers” (assuming your data has headers).In the dialog box that appears, scroll down and select Excel File.From the PowerPivot window, click Home, From Other Sources.Although this step is not essential, it is highly recommended. The safest approach here is to define a Named Range within the Excel source file first noting that range naming an Excel table also will not work as it must first be Converted to Range.Ĭolumn headings should be used within your data. If you are importing to Power BI both Range and Table names are recognised.
If you are importing data from one Excel workbook to another, Excel Tables are not recognised. External data located in a different workbook
0 kommentar(er)
