User Profile
andremendes
Regular Visitor
Joined 2 years ago
User Widgets
Contributions
Re: Power BI Service Refresh fails frequently.
The user logged in service has full access to the folder. It is good to note that the dataset size might have something to do with it, because I published a small dataset (a dimension with only 15 rows and 4 columns), and I configured it to be updated 8 times a day and it never fails1.3KViews1like0CommentsPower BI Service Refresh fails frequently.
We are getting a frequent error when Power BI Service tries to update my dataset, by schedule or manual updates. It is always the same error, the only thing that change is the table marked as "exceptionCulprit" here is the last error massage: Erro de fonte de dados: {"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":"A directory needed for evaluation could not be created. Directory: C:\\Users\\PBIEgwService\\AppData\\Local\\Temp\\Microsoft\\MashupProvider\\Cache\\g3p5wafy3eM+PiIRrrnfm@ievzIr0sYXEMNmZGqow374=\\Index. Details: (System.UnauthorizedAccessException) Access to the path 'C:\\Users\\PBIEgwService\\AppData\\Local\\Temp\\Microsoft\\MashupProvider\\Cache\\g3p5wafy3eM+PiIRrrnfm@ievzIr0sYXEMNmZGqow374=\\Index' is denied."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.HostingError.Reason","detail":{"type":1,"value":"DirectoryCouldNotBeCreated"}}],"exceptionCulprit":1}}} Table: RLS_ACESSO. Cluster URI: WABI-BRAZIL-SOUTH-B-PRIMARY-redirect.analysis.windows.net ID da atividade: 2591267f-a802-40d4-9dba-8dc7452bd7d6 Solicitar ID: 9b039ad1-a166-4e5c-9895-bd7bc316b63a Hora: 2023-11-06 18:39:33Z We already change server for the Gateway On-Premises (now is running in a 64gb of ram with 80+ gb of free space in disc). The Gateway is up to date In the last 17 update attempts, 2 were successful, so sometimes the update runs as intended, but most of the time, we get this error Some other information: Our dataset has 180mb We are importing the data (but we already tried with incremental update, and had the same problem) Does anyone knows how to resolve this?Solved1.4KViews1like2Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.