Forum Discussion
Error with automatic refreshes for Databricks source: Authentication/authorization error occurred
Hi Sunflower7500,
Thank you for reaching out to Microsoft Fabric Community.
Thank you Deku for the prompt response.
It’s likely related to how Fabric Capacity handles authentication differently than Pro. PATs sometimes don’t play well in Fabric refreshes due to security model differences. Try switching the Databricks connection to use OAuth2 in Power BI Service instead of a PAT. Also check your dataset’s credentials and gateway settings in the Fabric workspace.
If those don’t help, then go for opening a support ticket as suggested by Deku.
I recommend submitting your detailed ticket below:
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you.
I would talk to your networking team to figure out if any firewall rules have been added or changed
Hi Deku I figured out that the issue seems to stem from the workspace being a Fabric capcity. When I changed it back to Pro capacity, the server refresh succeeded. Do you know why I would only get this error in the Fabric capacity workspace and not in the Pro capacity?
No. Very weird. Might need a support ticket.
Hi Sunflower7500,
Thank you for reaching out to Microsoft Fabric Community.
Thank you Deku for the prompt response.
It’s likely related to how Fabric Capacity handles authentication differently than Pro. PATs sometimes don’t play well in Fabric refreshes due to security model differences. Try switching the Databricks connection to use OAuth2 in Power BI Service instead of a PAT. Also check your dataset’s credentials and gateway settings in the Fabric workspace.
If those don’t help, then go for opening a support ticket as suggested by Deku.
I recommend submitting your detailed ticket below:
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you.