Forum Discussion
Salesforce retiring API Connector
Salesforce is retiring API versions 21.0 through 30.0 in Summer 2025, and I’ve been informed that some of my Power BI reports were built using the Salesforce connector with API version v29.
Is there a way to identify which Power BI reports are currently querying Salesforce using an API version lower than 48, so I can update or rebuild those reports before they break? I didn't know if there was a way to do this without going into each individual report. Maybe something in the workspace where the reports are published or Salesforce?
Any tips on how to audit or detect API versions being used across multiple reports?
Hi KEO46 ,
You’re right to get ahead of this issue, since Salesforce is retiring those older API versions soon. There isn’t a built-in Power BI feature that scans all reports for connector API versions, but you have a couple of practical options:
- Enable Event Monitoring in Salesforce. This lets you see API usage logs and can help you identify which integrations—including Power BI—are using specific API versions. Look for connection events or logs that show the API version in use.
- Use the Power BI REST API to programmatically retrieve metadata for all your datasets. By inspecting the connection strings or details in the metadata, you may be able to spot which reports are using the Salesforce connector with an old API version.
- If you manage reports in workspaces, consider exporting the .pbix files and checking the connection details inside the files for the API version. This is a manual step, but it works if you only have a few critical reports.
Unfortunately, there isn’t a single-click way to audit all reports at once, so combining Salesforce Event Monitoring and Power BI REST API is your best bet for wider coverage.
If you need help with scripts or specific steps for either method, let me know your environment and I can point you to more detailed resources.
3 Replies
Hi KEO46 I think you can do this by enabling Event Monitoring in Salesforce to track API usage logs and identify Power BI connections using older API versions. Use Power BI REST APIs to retrieve dataset metadata and inspect connection strings for outdated API versions.
Hi KEO46 ,
You’re right to get ahead of this issue, since Salesforce is retiring those older API versions soon. There isn’t a built-in Power BI feature that scans all reports for connector API versions, but you have a couple of practical options:
- Enable Event Monitoring in Salesforce. This lets you see API usage logs and can help you identify which integrations—including Power BI—are using specific API versions. Look for connection events or logs that show the API version in use.
- Use the Power BI REST API to programmatically retrieve metadata for all your datasets. By inspecting the connection strings or details in the metadata, you may be able to spot which reports are using the Salesforce connector with an old API version.
- If you manage reports in workspaces, consider exporting the .pbix files and checking the connection details inside the files for the API version. This is a manual step, but it works if you only have a few critical reports.
Unfortunately, there isn’t a single-click way to audit all reports at once, so combining Salesforce Event Monitoring and Power BI REST API is your best bet for wider coverage.
If you need help with scripts or specific steps for either method, let me know your environment and I can point you to more detailed resources.
Hi KEO46,
I wanted to check if you had the opportunity to review the information provided by burakkaragoz Akash_Varuna . Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.
