Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
shatha
Frequent Visitor

How to increase number of columns imported from Salesforce object or select the columns to load

I had a problem loading SF object cases because it has over 660 columns and got the error msg "414): Request-URI Too Long"

 

I need to either increase the number of columns i am allowed to improt or pre-select the columns i need to load prior loading

 

please help

1 ACCEPTED SOLUTION

@v-haibl-msft

 

Thank you so much for the recommendation , but as my object contains over 660 columns I found it easier to use Table.SelectColumns and now it;s working fine.

 

Best  Regards,

Shatha

View solution in original post

5 REPLIES 5
v-haibl-msft
Microsoft Employee
Microsoft Employee

@shatha

 

How about the result if using RemoveColumns to delete the unnecessary columns in Advanced Editor?

 

Best Regards,

Herbert

@v-haibl-msft

 

Thank you so much for the recommendation , but as my object contains over 660 columns I found it easier to use Table.SelectColumns and now it;s working fine.

 

Best  Regards,

Shatha

Hi @shatha were you able to find a solution? As a workaround, maybe you can try to test your connection with a 3rd party connector, which pulls data directly from the SF objects API. I've tried windsor.ai, supermetrics and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options. In case you wonder, to make the connection first search for the Salesforce connector in the data sources list:

 

SALESFORCE-1.png

 

After that, just grant access to your Salesforce account using your credentials, then on preview and destination page you will see a preview of your Salesforce fields:

 

SALESFORCE-2.png

 

There just select the fields you need. It is also compatible with custom fields and custom objects, so you'll be able to export them through windsor.  Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url. 

 

SELECT_DESTINATION_NEW.png

Anonymous
Not applicable

@shatha and @v-haibl-msft, even I am facing the same problem. The solutions looks great but I am still confused. How and where do I write the function if the object is not even getting into power bi? I  mean power bi won't recognise the table and the column name until and unless the table is loaded in power bi.

 

I had the same issue and I finally found the solution, so for those that may have the same issue, here is the code to make it work:

let
Source = Salesforce.Data("https://xxxxxxxx.salesforce.com/", [ApiVersion=48, CreateNavigationProperties=true]),
Account = Source{[Name="Account"]}[Data],
#"Removed Other Columns" = Table.SelectColumns(Account,{"Id", "Name"})
in
#"Removed Other Columns"

 

The workaround is working for me, but then it means that I have to select all fields 1 by 1 from Salesforce then copy paste the names in the query. But at least it's working, which is better than before 🙂

I hope this can help others 🙂

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.