Power BI Refresh Error: Sharepoint Request Failed

[Anonymous]

Hey Everyone,

I'm connecting to an Excel file on SharePoint, but when the scheduled refresh runs, it fails with the following error.  

A few things I've tried

1) Refreshing in PBI Desktop: Works fine

2) Clear my permissions via PBI Desktop and publish to Server => My sch refreshed worked a few times after that, then stopped working again.

• Data source error{"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{"code":"Message","detail":{"type":1,"value":"SharePoint: Request failed: https://xxx.sharepoint.com/sites/ abc/SharedDocuments/BookofWork/dataset_xx_BoW_xlsx/_api/contextinfo"}}],"exceptionCulprit":1}}} Table: dim_xx_BoW.
• Cluster URIWABI-US-NORTH-CENTRAL-D-PRIMARY-redirect.analysis.windows.net

[lbendlin]

If you have a PRO license then raise a ticket to Microsoft. The more of us do that the more Microsoft will hopefully realize that this is a real problem, and not imaginary (pardon the pun).  Our users have multiple open tickets with them on this topic.  Rumors range from unannounced (and uncoordinated) schema changes by the Sharepoint team to impact from the TLS1.2 enforcement.  But these are just rumors.