Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Relationship not Working when applying view as role function

Hello,

 

I have encountered this issue. I've pasted values everything but still doesn't work. Could anyone extend their help please. Thanks

 

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hello Amy,

     

    I figured the problem. It's the spacing with the names. Thank you for your help and the advise. It's just that it's not the solution. Hope you won't stop helping me with other problems.

     

    Thank you

11 Replies

  • v-xicai's avatar
    v-xicai
    Community Support
    7 years ago

    Hi Anonymous ,

     

    Please make sure the correct name of the Server and Database for the visuals. Did you changed the Database name? If yes, you can change your current query source to your correct name.

     

     

    Best Regards,

    Amy

     

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hello v-xicai ,

       

      I don't know where to check coz it's not SQL server I am using it's just an excel and imported from my drive D. Please see screenshot.

       

      • v-xicai's avatar
        v-xicai
        Community Support
        7 years ago

        Hi Anonymous ,

         

        There are some points you can considerate.

         

        1.According to your error message, it refer to your data source have been changed, maybe changed the data source name or path to get data. So please check the path or name whether it is the same with your actual data source. Specially check the data source showing in your first screenshot .

         

         

         

         

         

         

         

         

         

         

        2.Please check you have permission to access to the Data model.

         

        Or this maybe a permission/authentication error. When you ever connect to data source in an unauthorized account, the corresponding credential would be created. You can change credential as steps below. Here take Dynamic 365 as an example.

         

        a.In Power BI Desktop, click Data source settings.

         

         

         

         

         

         

         

        b.Click Edit Permission ,or you can connect to blob storage again after click Clear Permission.

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

        3.Upgrade PBI Desktop to the latest version 2.68.5432.841, and try it again.

         

        Best Regards,

        Amy

         

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