We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
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.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.