Power BI PRO Differences with Desktop

[Jhwoods]

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 change?

[Anonymous · Accepted solution]

@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

[Anonymous]

'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?