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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Error during refreshing data set connected to SQL Analysis Services

Hello

Using Power BI Desktop I connected to my on-premise SQL Analysis Services (in import mode) and I made a report. Then I published this report to workspace in Power BI Service. I configured Gateway (I am using the same Gateway to bring other data stored in on-premise SQL Server tables and everything is working fine). Connection status = online and Gateway status = online. The report working itself and showing data (the data I set up in PowerBI Desktop) but when I am trying to refresh data set I am getting this error: AnalysisServices: The following system error occurred: The encryption type requested is not supported by the KDC.

Do any one know what may be wrong and how to fix it?

Regards

 

1 ACCEPTED SOLUTION
collinq
Super User
Super User

HI @Anonymous ,

 

I am assuming that you are using Kerberos based on that message.  If so, you have to configure Kerberos to allow Power BI to work with it.  Here are a couple links that will walk you through doing that:

Configure Kerberos to use Power BI reports - Power BI | Microsoft Docs

The encryption type requested is not supported by the KDC - SharePoint | Microsoft Docs

 




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




View solution in original post

1 REPLY 1
collinq
Super User
Super User

HI @Anonymous ,

 

I am assuming that you are using Kerberos based on that message.  If so, you have to configure Kerberos to allow Power BI to work with it.  Here are a couple links that will walk you through doing that:

Configure Kerberos to use Power BI reports - Power BI | Microsoft Docs

The encryption type requested is not supported by the KDC - SharePoint | Microsoft Docs

 




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors