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

[Anonymous]

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.

[v-qiuyu-msft]

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]

@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]

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]

@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]

Hi @Anonymous, 

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

Best Regards,
Qiuyun Yu