Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Can anyone help me understand what's causing this error message that happens when refreshing (manually or scheduled) in the online service on Premium? This is working fine on desktop refreshes. I can find no data that contains -2147467259 and my privacy settings are "None", but I've also tried "Organizational":
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":"Information is needed in order to combine data"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"Web\",\"path\":\"https://xxxxxxxxxx.sharepoint.com/sites/Shared%20Documents/General/Surveys/Short%20Survey.csv\"},{\"...}}} Table: Short Survey.
Solved! Go to Solution.
@v-xicai Apologies for not coming back to you. I followed your instructions, but changed nothing as everything was correctly set and still failed. However, a few days after raising this, the problems went away and refreshes worked correctly, so I believe this may have been a problem that Microsoft resolved on the service.
Hi @Anonymous ,
Does that make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.
Best regards
Amy
@v-xicai Apologies for not coming back to you. I followed your instructions, but changed nothing as everything was correctly set and still failed. However, a few days after raising this, the problems went away and refreshes worked correctly, so I believe this may have been a problem that Microsoft resolved on the service.
Hi @Anonymous ,
There are several points you may considerate:
1.Ensure that you've added one or more data sources of your dataset to the gateway, as described in Add a data source.
2.Verify that you have the correct username and password. Also, verify that those credentials can successfully connect to the data source. Make sure the account that's being used matches the authentication method.
3.Your data source credential may expire, so try to update the credential and republish the report. In Power BI, go to refresh settings for the dataset. In Manage Data Sources, select Edit credentials to update the credentials for the data source.
4.If your dataset not only contains cloud data source but also the on premise data source, then it needs to use the gateway and configure schedule refresh, see more: :On-premises data gateway , Configure scheduled refresh .
Note that you also need to select Allow user's cloud data sources to refresh through this gateway cluster option Under Gateway Cluster Settings. See: Merge or append on-premises and cloud data sources.
5.Please make sure the gateway is online, and try to upgrade the gateway to latest version. You might also need to upgrade the Power BI Desktop to the latest version 2.75.5649.961 . Download the pbix file from Power BI Service, then reopen in Power BI Desktop and republish to Power BI Service. See the similar case.
6.You may check your data source, and check if it is the similar case .
You may resolve the issue via the troubleshooting link :https://docs.microsoft.com/en-us/power-bi/refresh-troubleshooting-refresh-scenarios .
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.