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.
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 !
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 @
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?
Most likely your gateway is out of disk space.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.