Forum Discussion

jmdaher's avatar
jmdaher
Frequent Visitor
4 years ago

Refresh problem in power bi service

Hi! when i want to refresh my dashboard from power bi service appears the next warning:

 

What is the real problem? 

 

Thanks!

Need Help

2 Replies

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    4 years ago

    Hi jmdaher 

     

    It appears that the column you are using for the relationship does not have any data to create the relationship.

     

    What happens when you refresh the dataset can you view the data in the table?

    • jmdaher's avatar
      jmdaher
      Frequent Visitor
      4 years ago

      Hi GilbertQ!

       

      Here is the model:

       

      As you can see, I made a relationship between EContenedores table (in red) and #IDCarpeta table (in red) using the column ID Carpeta (in blue)

       

      The column ID Carpeta in #IDCarpeta table was created as you can see next: 

      I get the values of ID Carpeta column from the #IDCarpeta table. 

       

      When I refresh the dataset in power bi service I can´t see data in some visualizations (in green)

      these visualizations have columns from EContenedores table.

       

      But I don´t have this problem in power bi desktop.