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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
MaxBI
New Member

Dataset refresh problem

Hello,

 

I've a problem with the datasets of a customer :
- The refresh works randomly

DetailsTypeStartEndStatusMessage

 

Scheduled

7/24/2020, 12:30:00 AM

7/24/2020, 12:35:12 AM

Completed

 

Show

Scheduled

7/23/2020, 6:00:02 PM

7/23/2020, 6:02:57 PM

Failed

There was an error when processing the data in the dataset.

 

On demand

7/23/2020, 4:18:04 PM

7/23/2020, 4:26:39 PM

Completed

 

 

On demand

7/23/2020, 4:11:39 PM

7/23/2020, 4:15:23 PM

Completed

 

 

Scheduled

7/23/2020, 12:00:00 PM

7/23/2020, 12:05:23 PM

Completed

 

 

On demand

7/23/2020, 11:27:44 AM

7/23/2020, 11:37:01 AM

Completed

 

Show

On demand

7/23/2020, 11:24:53 AM

7/23/2020, 11:25:06 AM

Failed

There was an error when processing the data in the dataset.

Show

Scheduled

7/23/2020, 12:30:00 AM

7/23/2020, 12:30:14 AM

Failed

There was an error when processing the data in the dataset.

 

Scheduled

7/22/2020, 6:00:01 PM

7/22/2020, 6:05:56 PM

Completed

 

- I have an error message in the parameters (the issue's message is in french)

Data source error:

{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Impossible de créer un répertoire nécessaire à l'évaluation. Répertoire : C:\\Users\\PBIEgwService\\AppData\\Local\\Temp\\Microsoft\\MashupProvider\\Cache\\lWirCjl@iO5DvBaOV+V9id59wMVX@i0+SIGz3yKlGKUAE=\\Index. Détails : (System.UnauthorizedAccessException) L'accès au chemin d'accès 'C:\\Users\\PBIEgwService\\AppData\\Local\\Temp\\Microsoft\\MashupProvider\\Cache\\lWirCjl@iO5DvBaOV+V9id59wMVX@i0+SIGz3yKlGKUAE=\\Index' est refusé."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.HostingError.Reason","detail":{"type":1,"value":"DirectoryCouldNotBeCreated"}}],"exceptionCulprit":1}}} Table: Adresse site.

Cluster URI:

WABI-FRANCE-CENTRAL-A-PRIMARY-redirect.analysis.windows.net

Activity ID:

f07d2dbc-67ba-4373-8870-48d8e86581c7

Request ID:

2f8749b6-08f7-4c03-88cf-f8e4cb764ecf

Time:

2020-07-23 16:02:57Z

 

It's impossible to create the temporary directory by the gateway but the problem isn't constant. ("Unable to create a directory needed for the evaluation. Directory:......")

 

This message is the same for all of the datasets of my customer.

 

Have you an idea of this issue ?

 

Thank you !

 

 

3 REPLIES 3
venal
Memorable Member
Memorable Member

@MaxBI 

Please raise a support ticket to investigate the issue.

And share the latest error message in the support ticket to investigate the issue and share few screenshots.

https://powerbi.microsoft.com/en-us/support/

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
In case it does not help, please provide additional information and mark me with @

 

@venal 

Anonymous
Not applicable

it does seem to be a gateway issue and disk space.  

 

here are a few things to look at :

-Check to see if you have other refreshes that are running at the same time and adjust it

-Move to direct query over import 

-Use incremental refresh to keep refreshes small 

-with each report turn off "include in refresh" for each table that you dont need to always update 

 

Does that make Sense?

lbendlin
Super User
Super User

Most likely your gateway is out of disk space.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors