Forum Discussion
Sales Force Data connection updates
Hi Lydia, I think we have it working now, with your guidance I have realised, when you change passwords and locations of the data being used in the desktop APP. This information is not automatically updated to the WEB view and for each report and dahboard you need to update passwords as well and also I have to set the schedules as you have suggested. Thanks again for your support
Baz
Barry_1,
Do you connect to local Excel file in your PBIX file? If so, please install on-premises gateway(personal mode) on your machine, after you publish the PBIX file to Power BI Service, go to Settings->Datasets, find your dataset, enter credential for the salesforce and excel data source, then set schedule refresh for your dataset.
This way, when you have any data changes in salesforce and Excel, the dataset in Power BI Service will be automatically refreshed based on the schedule, and you don't need to manually re-publish PBIX file each time.
Regards,
Lydia
Lydia,
Thanks, the issues is all around salesforce and not Excel, I think the issue may be round my SF login rights.
I don't know, if you would know what the minimum requirements are for the SF login to allow the automatic updates to the dashboard from Saleaforce.
Thx
Baz
Barry_1,
As long as you are able to refresh the data in Power BI Desktop, you should be able to refresh the data from salesforce using same credential. How do you set schedule refresh for your dataset in Power BI Service? Could you please post a screenshot?
Regards,
LydiaLydia, I am excited now, I have not changed anything from day one and it worked, so I have just thought that somthing has changed in my Saleforce login. I an a self taught so may I have missed a step. I have not set up any refresh I thought this would be done as part of the GET DATA process? Could you explain where I set up this scheduling?
Thx
Baz
PS thank you for replying it is appreciated you taking the time...:)