Forum Discussion

jmartin0807's avatar
jmartin0807
Frequent Visitor
5 years ago
Solved

Data missing when connecting to published data set

Hi everyone, I have a problem that I cannot seem to figure out.   I have created a dataset in a PBIX file where I have a date table and a fact table. Like any good date table, there is a date for e...
Need Help
  • jmartin0807's avatar
    jmartin0807
    5 years ago

    Yes it has! So sorry for not checking this sooner. I'm not sure why this fixed the issue but it didn't have anything to do with hiding the column. Once I changed when I had the data refreshed, it solved the issue. Thank you everyone for your support.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

hi jmartin0807 - would you be able to share a pbix file with some sample data?

Also when you say you hid the Date column in the FACT table - are you referring to the column level hide as shown below? 

I have not experienced such an issue with missing data when you hide the relationship column - I have done it multiple models and it works perfectly fine. 

 

Hope that helps!