DB Errors, and refresh errors in Power Query

[Kareem_Amr_IT]

Hello, 

I have made a dashboard connections with the sources from a Sharepoint folder, and I wish to apply all the changes to query. However, when apply those changes, I get random errors, from 0x80040E4E Error - OLE DB or ODBC, to Sharepoint request failed, and an odd error about EARLIER/EARLIEST, but when I checked the query, such keywords do not exist. The problem is when I refresh the previews in the power query, the errors go away and the previews are displayed properly, then I try to apply again, the errors pop up randomly.

What can I do to fix this? 

Attached is the screenshot of the errors that happen during applying the query changes.

The code to the troubled queries  

Order_Details_With_Products

let

    Source = Table.NestedJoin(order_details, {"sku"}, product_master, {"sku"}, "product_master", JoinKind.LeftOuter),

    #"Expanded product_master" = Table.ExpandTableColumn(Source, "product_master", {"brand", "sku", "title"}, {"product_master.brand", "product_master.sku", "product_master.title"}),

    #"Filtered Rows" = Table.SelectRows(#"Expanded product_master", each true)

in

    #"Filtered Rows"

Order_details

let

    Source = Table.Combine({order_details_uae, order_details_ksa}),

    #"Merged Queries" = Table.NestedJoin(Source, {"customer .id"}, customers, {"id"}, "customers", JoinKind.Inner),

    #"Expanded customers" = Table.ExpandTableColumn(#"Merged Queries", "customers", {"company", "company_type"}, {"customers.company", "customers.company_type"})

in

    #"Expanded customers"

[v-easonf-msft]

Hi, @Kareem_Amr_IT 

You may need to open a support ticket  to confirm if this is a bug.

Best Regards,
Community Support Team _ Eason