Forum Discussion
Advocate IIDashboard Refresh Failed in PBI Service
Hello! I am getting an error message when I refresh my dashboard in Power BI Service. My data source is Salesforce and I have used the Salesforce connector. I mention that when I refresh it on my computer - Power BI Desktop - the refresh works fine. Also, this error I get for only one table. I have other dashboard with other tables and the refresh works just fine in PBI Service. I have tried to change the API - I usualy use API-48, but I have tried with AP after 48. I don't understand why it doesn't work in PBI Service. Does anyone has any idea?
Hi Elina_Mirin,
If you are still unable to solve the issue you can reach out to Microsoft Support by raising a ticket with Microsoft Support.
Please refer below link on how to raise a contact support or support ticket.
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft LearnBest Regards,
Hammad.
8 Replies
- Deku
Super User
It sounds like authentication or networking. Make sure your firewall or proxy is not blocking the Salesforce IP addresses
Elina_MirinI have tried with firewall off, but still not working for this specific table from Salesforce: CampaignInfluence. I don't have any issues with lead, opportunity, contact tables from Salesforce - these refreshes in Power BI Service without any issue.
rohit1991Hi Elina_Mirin
Since the refresh works in Desktop but fails in the Service, it usually points to a difference in credentials or access between the two. If only one Salesforce table is failing, it’s worth checking a couple of things:
-
Make sure the dataset credentials in Power BI Service are up to date and re-authenticate if needed.
-
Double-check that the Salesforce object still exists, hasn’t been renamed, and that your account in the Service has permission to it.
Most of the time this sort of 404 error comes down to the Service not being able to “see” that object the same way Desktop does. If all looks fine and it still fails, then I’d suggest opening a ticket with Microsoft Support so they can trace it further.
-
Hi Elina_Mirin,
Thanks for reaching out to the Microsoft fabric community forum.
It looks like the refresh works fine in Power BI Desktop but fails in the Service, and only for one specific table, this sounds like a compatibility or access issue between the Power BI Service and Salesforce for that particular object.
You can consider rechecking few thing(s) suggested by rohit1991like the 404 error which typically means the object doesn’t exist or can’t be found at the specified endpoint or the restricted visibility or permissions in Salesforce, and the credentials configured in the Power BI Service.
I would also take a moment to thank rohit1991 and Deku, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Hammad.
Community Support TeamIf this post helps then please mark it as a solution, so that other members find it more quickly.
Thank you.
Hi Elina_Mirin,
As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.
If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.- Elina_Mirin
Hello! Thank you all for your responses. I haven't found a solution yet. I still get error when refreshing in Power BI Service. The temporary solution is to refresh the dashboard locally and then publish it in Power BI Service. But this will not work long term, as the dashboard needs to be refreshed on a weekly basis.
