Forum Discussion
Refresh Fails - More Recent Gateway
- 6 years ago
Hi Anonymous ,
Glad to hear that you have resolved your problem. Thank you for sharing this. If you have any other questions, please kindly ask here and we will try to resolve it.
Best regards,
Anonymous Do you get any failures if you open the PBIX file and go into Transform Data (Power Query) and refresh any of the quieres? Sometimes I've found that something changed or my settings/permissions on the data source got messsed up in the file and they need updating.
- Anonymous6 years agoNot applicable
Thanks Seth - I have no problems manually refreshing the dataset from the pbix file directly. Dailey I manually refresh everyday and Publish to the Power BI portal. (sort of a pain ;o)
- Anonymous6 years agoNot applicable
Anonymous My point is I have had files that refresh successfully in the PBIX file, but when i go dig into the query itself I start to see errors. Those errors for some reason got bypassed in the PBIX refresh, but caught in the gateway refresh and failed it. I would recommend checking all your datasource credential settings that you are using in the file, as that appears to be the issue.
File - Options and Settings - Data source settings after checking your PQ queries.