Forum Discussion

Element115's avatar
Element115
Memorable Member
3 years ago
Solved

Power BI Service refresh error when using custom M functions for REST API calls + on-prem gateway

Power Query Team, please find a way so that REST API calls from various custom functions within local queries calling Table.AddColumn(a_table_as_prev_query, new_col_name, each custom_fun(), col_type)...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Element115 ,

 

This can have several problems behind, check the documentation below with information about possible errors and examples:

Dealing with errors - Power Query | Microsoft Learn

Behind the scenes of the Data Privacy Firewall - Power Query | Microsoft Learn

Or please refer to the following similar posts and try these inside solutions:

Solved: POWER QUERY references other queries or steps - Microsoft Power BI Community

Solved: References other queries or steps, so it may not d... - Microsoft Power BI Community

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Element115's avatar
Element115
Memorable Member
3 years ago

Thanks, Stephen!  Didn't know about the Data Privacy Firewall.  However, still would be great if Microsoft could put up a web page where we could plug in error codes such as 

				{
					"code": "DM_ErrorDetailNameCode_UnderlyingErrorCode",
					"detail": {
						"type": 1,
						"value": "-2147467259"
					}
				}

and get redirected to a page explaining the probable cause in more details than the JSON error message and with a link(s) to the specific page(s) of the documentation pertinent for the error code.  Just saying.