Forum Discussion
Salesforce + PowerBI
- 2 years ago
Hey Dwalden ,
I think that you will have to go into Query Editor, into the Advanced Editor for that field and manually remove it (in all the places it appears). This is not always the best solution but sometimes I think that fields that were once there (and or had information in them) just "stay" in the query because it was valid and you have to go and just remove it manually from the query itself.
Power BI works well with Salesforce, but API limits can cause slowdowns when dealing with large data or complex queries. A good approach is to first copy Salesforce data into a database or data warehouse — then Power BI connects to that instead of querying Salesforce directly. There are tools like Skyvia that let you sync data without coding, which helps reduce API load and makes reports run smoother and more reliably.