Forum Discussion
Scheduled refresh problem (joining sources), need help understanding the error message.
I've managed to get the refresh working
The solution was actually rather different than the direction I was working in.
Instead of splitting up all queries into sepparate tables and loading them, I've placed everytihing in a single query.
This is rather ugly but makes the refresh work.
I am now working on breaking up the code into functions to make it readable again, until something breaks again...
TIL (today I learned):
One should test scheduled refresh from the start of development and keep testing for every noteworthy change in architecture.
I think your problem is table 1. Break that into 3 distinct tables, then use Table.Combine (Append) to combine them.
THere are issues with the service merging tables when you get clever with the source lines.
For example, if you create one table that is a source to a SQL database, then 2 reference quereis that database then each select a table from that single line source, then you merge either of those with another data source, like SharePoint, it works great in Power BI desktop, but will not work in the service.
I've managed to get the refresh working
The solution was actually rather different than the direction I was working in.
Instead of splitting up all queries into sepparate tables and loading them, I've placed everytihing in a single query.
This is rather ugly but makes the refresh work.
I am now working on breaking up the code into functions to make it readable again, until something breaks again...
TIL (today I learned):
One should test scheduled refresh from the start of development and keep testing for every noteworthy change in architecture.