Analyze in excel issue

[nikita_09]

Can anyone help me out with this issue adding a screensot of it . i was not able to understand what is the issue exactly. I'm using direct query option for my fact table.

[v-eqin-msft]

Hi @nikita_09 ,

Thanks for sharing the solution!

Could you please kindly Accept your reply as the solution to make the thread closed. More people will benefit from it!

Best Regards,
Eyelyn Qin

[v-eqin-msft]

Hi @nikita_09 ,

As the error message said, it maybe caused by wrong credentials.

What's your data source? Could you refresh the dataset successfully? Please check if the signed account in Analyze in Excel is same as in Power BI Service.

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

[nikita_09 · Accepted solution]

this was the solution as we were selecting this option for restricting others credentials (without knowing) in direct query option as our data is connected directly to snowflake