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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Salesforce Report Automatic Refresh to Power BI Desktop and Power BI Service

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 🙂

1 ACCEPTED 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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

9 REPLIES 9
v-yuezhe-msft
Employee
Employee

@Anonymous,

Are you able to set schedule refresh for your salesforce dataset in Power BI Service?
1.JPG

Regards,
Lydia 

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

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.
1.JPG

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors