PowerBI Partner Connect with Databricks Error

[Anonymous]

I am attempting to utilize the Partner Connect feature to link tables I am modifying and creating in Databricks to models and dashboards in PowerBI. Initially, I had to go to our security and compliance team to get my Databricks endpoint whitelisted. Once I had done that, I was able to connect and select tables using Partner Connect for a week or so. And then this morning I started getting the folloiwng error when attempting to re-select the table I had been using.

It seems to be an ODBC error because the "result file URL has expired" and when I decode the UNIX timestamp it goes back to the time when this error started occuring. How do I stop the result file URL from expiring?

[v-jingzhang]

Hi @Anonymous 

I guess perhaps some configuration information in the downloaded connection file had expired. Or the credentials or token used for sign-in had expired. You can try going to Data source settings and clear the permissions on this data source. Edit credentials again and see if this can let you connect to the data source again. 

If clearing&reediting permissions doesn't solve this problem, go to Power Query Editor and open Advanced Editor. Check how the connection is composed in it. See if there is any info that may have expired and need updating. 

Best Regards,
Community Support Team _ Jing