Forum Discussion
Helper IIDataset refresh manually, but fails when scheduled
Finally, found the solution.
I have found the root of the problem and it seems to be the appending of two tables. I have checked with different possibilities and all the way seem to refresh, but not the append one.
initially, I appended the large table with small one and this throws the error. By appending the sammler table to large table, The problem is fixed.
I can now schedule the refresh and the dataset is refreshed at the scheduled time
Regards
Fazil M
Community SupportHi M0hamedFazil ,
Thanks for reaching out to the Microsoft Fabric Community Forum.
In addition to ibarrau let me add more insight to the above :
Error Code: DM_GWPipeline_Gateway_MashupDataAccessError
This indicates there is a problem in the data pipeline while accessing or processing the data from the source.
Here are some steps to troubleshoot and resolve the issue:
1. Ensure that your Power BI gateway (if using one) is connected to the data source properly and that there are no issues with the connection.
2.Verify that the credentials used to access the data source are correct and have the necessary permissions.
3.Try refreshing the data to see if the error occurs consistently or intermittently.
4.Ensure the ODBC driver is installed on all machines running the Power BI Gateway.
Check if there are any specific configuration requirements for the ODBC driver in terms of networking, permissions, or service accounts.
5.Go to the Power BI Service, navigate to the Data Source Credentials section under your dataset settings, and ensure they are correct.Test the credentials by manually refreshing the dataset.
You can check the similar solved case : Solved: New ErrorCode=-2147467259 - Microsoft Fabric Community
If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.
If you continue to face issues, feel free to reach out to us for further assistance!
Helper IIHI v-aatheeque
Sorry for the delay in response as I'm struck with different work.
I tried and check all the solutions you listed, I can't see to find the problem till now. Now when manually refreshed it throws the same error, which didn't happend before.
Thanks for checking on
Regards
Fazil M
- ibarrau
Super User
Hi. Open de PowerBi Desktop original file. Refresh it. If it finishes correctly, then open the Query Editor and look for errors manually. Check at the buttons looking for Keep rows with error, something is odd and it might be a small issue in data that is preventing the refresh.
I hope that make sense
- M0hamedFazil
Hello ibarrau ,
The Dataset refreshs manually and I have checked with all the transformations, I checked with the errors too. I didn't ignore any and I corrected those errors. Thanks for the reply and I will let know if I got to find the solution.
Regards
Fazil M
