Forum Discussion
Data Refresh Issue in Power BI Service with Microsoft List Source
Hi, I've found the solution.
On inspecting the M language, I have 4 merges.
In Desktop all queries often evaluate locally and consistently
In Service. Queries are evaluated independently
Join tables may:
- Not fully refresh in time
- Return slightly different schemas
- Have privacy/firewall differences
The solution is: Before each merge, buffer the lookup tables
SubmittedBuffered = Table.Buffer(Submitted),Another mystery was why it suddenly failed after working for nearly an year.
One potential reason is that Microsoft's backend optimisation updates may have forced the join to occur first before loading the tables.
Hi, I've found the solution.
On inspecting the M language, I have 4 merges.
In Desktop all queries often evaluate locally and consistently
In Service. Queries are evaluated independently
Join tables may:
- Not fully refresh in time
- Return slightly different schemas
- Have privacy/firewall differences
The solution is: Before each merge, buffer the lookup tables
SubmittedBuffered = Table.Buffer(Submitted),
Another mystery was why it suddenly failed after working for nearly an year.
One potential reason is that Microsoft's backend optimisation updates may have forced the join to occur first before loading the tables.