Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
shivakumardr1
Regular Visitor

Data bricks connectivity from Power BI service.

Hello All,

 

I have connected to a Databricks SQL warehouse from Power BI desktop through access token and I am able to fetch the data and build the report. When I publish the report into Power BI service and try accessing the visuals I get the error message as below.

Couldn't load the data for this visual

[Microsoft][ThriftExtension] (14) Unexpected response from server during a HTTP connection: Unauthorized/Forbidden error response returned, but no token expired message received.. The exception was raised by the IDbCommand interface.

Please try again later or contact support. If you contact support, please provide these details. 
 
I have gone to the settings of the dataset and have entered the access token in service too. Also, when I try to refresh the dataset and go to the refresh history it shows completed as below. 
shivakumardr1_0-1716636018936.png

So, to summarize, I am able to access the dataset from Power BI desktop but not able to access the dataset from service using the same token. Any pointer on how to go about fixing this would be of a great help!

 

Thank you!

1 ACCEPTED SOLUTION
v-jiewu-msft
Community Support
Community Support

Hi @shivakumardr1 ,

Based on the error description, try to review the token whether has expired.

Besides, try to check the dataset credentials.

vjiewumsft_0-1716780237585.png

You can also view the following documents to learn more information.

Databricks Power Query Connector - Power Query | Microsoft Learn

Set up your Azure Databricks connection - Microsoft Fabric | Microsoft Learn

Connect Power BI to Azure Databricks - Azure Databricks | Microsoft Learn

 

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-jiewu-msft
Community Support
Community Support

Hi @shivakumardr1 ,

Based on the error description, try to review the token whether has expired.

Besides, try to check the dataset credentials.

vjiewumsft_0-1716780237585.png

You can also view the following documents to learn more information.

Databricks Power Query Connector - Power Query | Microsoft Learn

Set up your Azure Databricks connection - Microsoft Fabric | Microsoft Learn

Connect Power BI to Azure Databricks - Azure Databricks | Microsoft Learn

 

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors