Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Blank rows showing in table when reference given to table in another Excel file

Hi everyone! Here's what I'm trying to do, and my problem (with screenshots). I would like to have a master spreadsheet that I use as my underling database for a PowerBI report. Everything is workin...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

Note that Power BI allows you to distinguish between Excel sheets and Excel tables as data sources. Define your tables as needed in Excel and you get the contents automatically. Or choose to connect to the sheet and filter the unneeded rows in Power Query.