Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
Has anyone figured out how to set daily or half daily refresh from Salesforce Report to Power BI Desktop/Service.
I have this issue when Salesforce Report is being updated, it does not automatically captured on Power BI Service.
I will have to manually refresh it daily or half daily.
I am fine with any quickest and simplest solution, either a auto-refresh from Salesforce side or from Power BI side.
Hope to hear from anyone soon!
Thank You 🙂
Solved! Go to Solution.
@Anonymous,
What credential do you use to connect to Salesforce report in Power BI Desktop? Just enter same credential in Power BI Service after you upload PBIX file.
Regards,
Lydia
@Anonymous,
Are you able to set schedule refresh for your salesforce dataset in Power BI Service?
Regards,
Lydia
Hi Lydia,
Here is the issue I am facing.
*Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again.
My dataset is imported as "Salesforce Report" and refresh set up is is gray outed.
Regards
Winson
@Anonymous,
I get error 400 when entering salesforce credential under Data source credentials, and this issue has been reported internally.
Do you get same error code?
Regards,
Lydia
No I do not get the same error code as yours.
What I have read through is that the dataset from Salesforce Report will be automatically refresh once daily. You cannot set the refresh date on your own.
Correct me if I am wrong.
Thank You
Winson Chong
@Anonymous,
As long as you can successfully enter credential under Data source credentials, you can add other times to refresh. But you are limted to refresh 8 times a day.
Regards,
Lydia
I guess I will have to work with Salesforce Developer / Admin Team to allow authorization for Power BI. This means it would be the issue on Salesforce side. Thank you for your support 🙂
@Anonymous,
What credential do you use to connect to Salesforce report in Power BI Desktop? Just enter same credential in Power BI Service after you upload PBIX file.
Regards,
Lydia
It works after authentication.
Thank you so much 🙂
@Anonymous,
Glad to hear the issue is solved, please accept my previous reply as answer, this way, other community members would easily find the answer when they get same issues.
Regards,
Lydia
User | Count |
---|---|
25 | |
13 | |
12 | |
11 | |
8 |
User | Count |
---|---|
44 | |
27 | |
19 | |
16 | |
12 |