Forum Discussion
Solved
Power BI PRO Differences with Desktop
Why does my Excel Data need to be in Tables in PRO. It does not require this in Desktop? Painful to try and publish some Charts. Tables cause problems and errors in my workbook? Will this cha...
Jhwoods,
Please take a look at the following online articles. It requires to format data in table if you directly connect to Excel workbook in Power BI Sevice.
https://docs.microsoft.com/en-us/power-bi/service-admin-troubleshoot-excel-workbook-data
https://docs.microsoft.com/en-us/power-bi/service-excel-workbook-files
Regards,
Lydia
'Power BI PRO' is the standard Power BI Desktop software. It just means you're using a Pro license rather than Premium Capacity.
Are you referring to 'Power Pivot for Excel' requiring data to be in a table for it to be consumed by Power Query?