Forum Discussion
Solved
Data heavy Excel reports in Power BI
I am currently working on migrating a few Excel reports to Power BI. Because of business requirements, some of our reports have many rows and columns (107 columns for one report). The Power BI versio...
Hi Bikhod2 ,
You are correct on your conclusion, please see my comments on the points you refered:
- Excel the data is presented as a table with Excle table style applied (coloured rows) to make it easy to see the data - This is possible you can have alternate backgrounds
- Each column can easily be filtered using the default Excel table behaviour - This can be done using the filter pane and not directly on the column. There are some visuals on the app source that also allows this direct filter
- Each column can be easily filtered using the filter by text etc features of Excel# - Same as previous
- Our business users are very comoftable with Excel - No comments on this 😄
- Sometimes users can, and do, add additional columns using Excel formulae - This is not possible in Power BI, altough there are some visualizations that currently allows this but they are not free.
This is a very different program from Excel they work very well together, if you wan to keep the excel possibilities please check the links below:
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel
MFelix
Super User
Super UserHi Bikhod2 ,
You are correct on your conclusion, please see my comments on the points you refered:
- Excel the data is presented as a table with Excle table style applied (coloured rows) to make it easy to see the data - This is possible you can have alternate backgrounds
- Each column can easily be filtered using the default Excel table behaviour - This can be done using the filter pane and not directly on the column. There are some visuals on the app source that also allows this direct filter
- Each column can be easily filtered using the filter by text etc features of Excel# - Same as previous
- Our business users are very comoftable with Excel - No comments on this 😄
- Sometimes users can, and do, add additional columns using Excel formulae - This is not possible in Power BI, altough there are some visualizations that currently allows this but they are not free.
This is a very different program from Excel they work very well together, if you wan to keep the excel possibilities please check the links below:
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel
Thank you Miguel for your very useful and comprehansive reply.