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
chloristan_
New Member

Dataset Refresh

I tried to refresh my dataset in the app.powerbi, but it hits error or takes very long to refresh. Does anyone knows how can I refresh my powerbi dataset?

 

chloristan__1-1687946631133.png

 

Error shown

chloristan__2-1687947391152.png

Data source error: The credentials provided for the Dynamics365BusinessCentral source are invalid. (Source at Dynamics365BusinessCentral.). The exception was raised by the IDbCommand interface. Table: evLocations.
Cluster URI: WABI-SOUTH-EAST-ASIA-B-PRIMARY-redirect.analysis.windows.net
Activity ID: da129b7c-3ba5-4b75-9b53-11b868f35c6f
Request ID: b5b356e2-0327-fdf1-9c3f-7533054f1138
Time: 2023-06-28 10:01:56Z

 

 

2 REPLIES 2
ibarrau
Super User
Super User

Hi. There is an issue with the credentials used for Dynamics365BusinessCentral source. You need to enter them again. If you have a gateway, go to the source and edit the credentials there. If you are connecting directly from cloud go to "Schedule Refresh" setting of the dataset. Look for "Data Source Credentials" section and edit the credentials of the source. Then refresh again.

I hope that helps,


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

DavidS524
Helper I
Helper I

Hi @chloristan_ ,

Go into the settings for the dataset and review your gateway settings and data source credentials. You can try different credentials if applicable. It is hard to say without more detail but there are a number of things that could be wrong here. Perhaps someone was using their personal credentials to authenticate, but now they have left the company? Ideally you would want to use a service account and make sure it has all the required permissions.

 

Aside from credentials, there are numerous things you can look at to try and optimize refresh times. Just a few of the basic ones are:

 

1. Review how much data you are pulling into your report. Can you filter it down to a smaller subset of rows?

2. Do you have numerous columns that are unused in your report? Remove them wherever possible.

3. Depending on your data source, there may be timing issues. For example, if you are pulling from a SQL table or stored proc, try to find out if there are other jobs/reports running against that table at the same time you are refreshing. Or, if you have other reports on Power BI Service aall refreshing at the same time you can try spreading them out.

Hopefully that gives you a starting point!

Helpful resources

Announcements
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.