Problem summary
Power BI loads the same dateless rows more than once. With the default settings, each row can appear 12 times.
Error message or symptoms
Your Power BI table contains repeated rows that have no value for Funnel's Date dimension.
When does this occur
The Data Share contains rows without a value for the Date dimension.
The Rolling months value is greater than
1.
Root cause
Power BI requests data from Funnel in one-month batches. A dateless row does not belong to a specific month, so the connector returns it for each requested month.
Solution
In Power BI, set Rolling months to 1. Power BI then loads each dateless row once.