Data Still Not Refreshing on Service

Hi Everyone,

This was one of the most frustrating experiences I have had with PBI, but it is resolved now, and I just want to share what caused my issue in case anyone else is ever in the same predictament I was in.

I was able to solve the issue when I started to rebuild my report.  I started with my two dimension tables (customer master and date table) and then my two fact tables, one with all invoices up to the end of 2020 and a second with invoices from Jan 1, 2021 and after, which were then appended in power query (PQ) into one summary fact table. 

After setting up the two tables in PQ, I went to set up my relationships and noticed that my summary fact table had the relationships set-up automatically to both dim tables correctly, but the second fact table (2021 and after) had only one relationship detected and created.  This made me wonder why the first table had two relationships created automatically, but the second ony had one, so I went back to a working version of the report from earlier in the year, and noticed it did not have any relationships between the second fact table and the two dim tables.  So I went back to my troubled report, noticed that there was one relationship in it as well between the second fact table and one of the dim tables and removed it, and that corrected my problem.  Since then, the report has been working.

I believe this issue was caused because I recently had to rename the datasource file for second fact table (2021 on after) and when I did that, I assume this relationship was created.  

Anyway, hopefully that helps someone.  This one incorrect relationship caused me many many hours of work and frustration.