Forum Discussion
Excel DataSource doesn't load completely
Hi, Power BI beginner here. I am creating a dashboard with multiple excel sources . The excel file currently has 300k+ rows !! (I recommended not to use excel for storing data but the end us...
I checked on the file and no blank rows in between and no defined table / range as well. It is actually an output file from Alteryx where new rows of data are appended to the existing sheet. Also I tried automated workflow to save it as csv file and there were no issues. Solved my problem for now, but i am still curious to understand as to why there is problem in loading the file in .xlsx format