Hi Team

Our internal customers web-based EOM data is populated monthly.  I can download and save into an excel easy enough.

The question is how am I best to save it and in what format to allow easy connection to Power BI.  The data will be the same but will grow by 3000 lines each month.

Should it be 1 big sheet or is there a better way?  Should I save it as a table or raw data?

​Hi TeamOur internal customers web-based EOM data is populated monthly.  I can download and save into an excel easy enough.The question is how am I best to save it and in what format to allow easy connection to Power BI.  The data will be the same but will grow by 3000 lines each month. Should it be 1 big sheet or is there a better way?  Should I save it as a table or raw data?     Read More

​