Hi @Ved88 ,

If I remember correctly I got similiar error when I tried to set it up on my project. What I did to make it work was to use  EnableQueryResultDownload="0" in power query source definition. 

= Databricks.Catalogs("xyz.cloud.databricks.com", "sql/protocolv1/o/0/clusterxyz", [Catalog=null, Database=null, EnableExperimentalFlagsV1_1_0=null, EnableQueryResultDownload="0"])