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.

v-lionel-msft's avatar
v-lionel-msft
Community Support
5 years ago

Hi jmartin0807 ,

 

" I noticed in my date table, each year only has dates from January to June, everything else was missing. I didn't filter or change the date table at all."

 

The calendar table in your data model only has data from January to June? Or does the date field in the table visual only have data from January to June?
If it is the former, please check Power Query and data source, if it is the latter, it may be that the field in the fact table affects the date field (Show item with no data).