Forum Discussion

nikita_09's avatar
nikita_09
Frequent Visitor
5 years ago
Solved

Analyze in excel issue

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.

 

  • 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

     

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
      nikita_09
      Frequent Visitor

      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

       

  • Anonymous's avatar
    Anonymous
    Not applicable

    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