Problem with Power BI not showing data

[aidon_hudson]

Connecting to Dynamics CRM online 2015 directly and trying to pull a table which is an extension custom built for our company.

When using the Power Query extension for excel the data shows fine but doesn't in Power BI.

I was wondering what was the limit? Due to us having 220 rows but around 170 columns.

[Seth_C_Bauer]

@aidon_hudson this sounds simliar to a different thread, check the fix out at the end that worked for that user.

http://community.powerbi.com/t5/Integrations-with-Files-and/Error-trying-to-get-data-from-Microsoft-...