Forum Discussion
Helper Irefresh failed since June's update. with error: We cannot convert the value "[Table]" to type Table.
Hi Selina,
it works again since yesterday afternoon (Pacific Time).
thanks,
Celine ZHANG
Helper IHi Selina,
Thanks for following up my issue.
It happens only with Power BI service, with Power BI desktop it works perfectly.
I created a very simple testing/debug dataset, only to test this issue, it happens all the time just with this merge, delete the merge line, no issue.
Thanks for helping, it’s disturbing our business process/reports.
Hi lotus99 ,
I find the reason why the issue happens with line merged.
For incremental refresh, it needs to meet some basic requirements, one of which is that the data source needs to be able to support query folder. But I checked the limits of the query folder and was surprised to find that merging would prevent it, as you did, if you performed the merge, the incremental refresh would fail, and canceling would work fine.
The following is the related docs, limitations about query folder are in the first doc, you can refer it for more information, the second doc is about incremental refresh, including its process and basic requirements.
Query folding - Power Query | Microsoft Docs
Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Docs
Best regards,
Community Support Team Selina zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
- lotus99
Hi Selina ,
thanks for the investigation.
I don't perform incremental refresh, just regular simple refresh.
I'm puzzled from when to merge data, we need care about their source, need to be directly accessed?
the previousely sliced and diced data done in dataflow, cannot be merged with Excel data from SharePoint?
Hi lotus99 ,
Did you succeed in refreshing in power bi desktop?
I find one blog and the reason leading to your error is as the following says, so do you combine an external data source?
And from your error, it says that your merge queries have something wrong, so may be you need to check your query.
In the following docs , there has related solution to solve this error, you can refer to it and try.
Power Query Errors: Please Rebuild This Data CombinationThe Excelguru Blog
If it doesn't work , you can think about putting every stages used for the query in a single BIG query.
Solved: Refresh problem - Unable to combine data - Microsoft Power BI Community
Best regards,
Community Support Team Selina zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
- lotus99
Hi Selina,
it works again since yesterday afternoon (Pacific Time).
thanks,
Celine ZHANG