Forum Discussion
Trouble connecting to data source (Excel file, not in table format)
I manage an Excel file that contains 222 columns and it currently has around 2000 rows. The file size is around 3.39MB. It is not in Table format and it has many custom formulas. Power BI cannot conn...
Hi Nathaniel, I counted how many columns I have in the Excel file and there were 222. I see Power BI "thinking" that there are around 240 or so. I cannot figure out why that would be the case. I cannot move that file onto a new file because then many formulas would break in other tabs.