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

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

When trying to use Power Pivot in excel with powerbi dataset error throws up

When trying to use Power Pivot in excel with powerbi dataset the below error throws up

 

Failed to connect to the server Reason:- Invalid value for the key : Integrated security  . Please help.

 
Status: New
Comments
v-qiuyu-msft
Community Support

Hi @Anonymous, 

 

Which feature did you use to connect to Power BI dataset in Excel, Power BI publisher for Excel or Analyze in Excel? May I know which specific step causes this issue? 

 

Best Regards,
Qiuyun Yu

Anonymous
Not applicable

@v-qiuyu-msft ,

We were using PowerBI dataset in Excel . When we tried to go to the Manage Data Model--> Get Data--> Existing Connections then clicked on the powerbi dataset connection and then we get the error.

v-qiuyu-msft
Community Support

Hi @Anonymous, 

 

Was the existing connection created by Power BI publisher for Excel feature? 

If it is, it's a limitation listed here

 

"Using Tables instead of Data models - Datasets and reports that are created by importing only tables from Excel (without a data model) are not supported at this time, and cannot be connected to."

 

Best Regards,
Qiuyun Yu 

Anonymous
Not applicable

@v-qiuyu-msft ,

 

Thanks for the response. Yes, I was using PowerBI publisher for excel. I have tried this because of another issue I faced. I tried to have the dataset published in powerbi service. Everything comes up but the powerbi hierarchies created in powerbi is not apopearning in the excel . This is because the table is set in dual mode . But when i changed to import mode then the hierarchy is coming up but when the hierarchy is dragged to the excel pivot,  I'm gettting the error stating that the OLAP query could not be processed and the item couldnot be found on the Olap model.My source is snowflake. I even tried with excel the same issue occurs. Any idea why this is happening?

 

 

 

v-qiuyu-msft
Community Support

Hi @Anonymous, 

 

I would suggest you create a support ticket to get help. 

 

Support Ticket.gif

 

Best Regards,
Qiuyun Yu