Forum Discussion
AmandaSoborg
8 years agoAdvocate II
SalesForce missing columns
Hi everyone When i Download my salesforce report (with 44 colums) only 30 of them shows up in Power BI. I know there is a limit to 2000 rows, but that doesn't apply to columns, right?
v-jiascu-msft
8 years agoMicrosoft Employee
Hi AmandaSoborg,
According to this document, the limitation should be up to 100. I would suggest:
1. Upgrade the Power BI Desktop to the latest Version: 2.51.4885.701 64-bit (October 2017);
2. Try the Salesforce Objects instead, which has little limits.
>>>The API can process only reports that contain up to 100 fields selected as columns.
Best Regards!
Dale
AmandaSoborg
8 years agoAdvocate II
I have also treid the Objectives, but i find it hard to find all of the nesesarry data when doing it this way. Therefore i would like to download the report.
In SalesForce i have a lot of different values under a Folder. But when i am connecting to SalseForce through Power BI i cannot find these folders. If I could do it this way, I would use Objectives instead of Reports.