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

v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity 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
      Icon for Community Support rankCommunity 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.

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hello v-xicai ,

         

        Good morning!

         

        My apology of not replying immediately. Anyway, I really appreciate your time and effort of sharing your ideas on how to solve my issue. But you know when I try to follow your step choosing the global permission, it says but it's working on my other geography with the same result in global permission