Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I'm experiencing a problem with deploying my dataflow using one of my deployment pipelines.
The pipeline has three workspaces connected (all premium and I have pro licence). When I try to deploy one of the dataflows from dev to test, I get error
:
I had this error already recently and I couldn't find solution so I exported the dev dataflow to .json, delete it on dev, test and prod, imported it again to dev and pulled thru pipeline. I worked once, now I try to make another change and the problem repeats.
I tried to submit a support ticket, but the support page seems to be broken as well - the form is not displaying and there is an error in the browser console (Uncaught (in promise) No response received for 'loadNewTicket' message in 5000 ms)
To be clear - all workspaces are premium, I have a pro licence, I operate in my company MS environment, I have been using this pipeline for many months now, with multiple dataflows, dataset and reports objects and everything else works fine, it's just this one dataflow.
I has credentials entered, when I edit it, it validetes with no error and refresh on dev with no errors.
Any idea what may cause this error ?
Hello
I'm a little bit late, but i had the same error "All entities and corresponding polling queries should have entries in the query metadata", with a dataflow at deployment from [Dev] to [Test].
Cause / reason : Incremental Refresh on [Test] Environnement but not in [Dev] Environnement
Thanks @cedric_267 ,
your tip with the incremental refresh solved my issue. I removed it in Dev & Test and then had issues during deploying it to Prod. It is pity that MS cannot catch and report this issue properly. We only get this vague error message.
Thanks again and have a great day.
Hi , @sartys
Thanks for your provided the error code , and i search this code in the Microsoft backend database.
I find this detailed errror:
Exception object created: Microsoft.PowerBI.WorkerService.ContentProvider.CopyOverwriteUsageException: All entities and corresponding polling queries should have entries in the query metadata
For this , you can first check if you meet the limitation for the dataflow, you can refer to :
The Power BI deployment pipelines process - Power BI | Microsoft Learn
Create deployment rules Power BI Application lifecycle management (ALM) - Power BI | Microsoft Learn
And for this error code ,the error message suggests that there is an issue with the query metadata of your dataflow.
You can check the query metadata of your dataflow. Ensure that all entities and corresponding polling queries have entries in the query metadata.If any entities or queries are missing, you need to check and refresh them.
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @v-yueyunzh-msft , thank you for your anwser. Could you please explain me in more details how to "check the query metadata of your dataflow" and what should I look for ?
Hi Sartys,
Did you manage to sort this out? I am facing the same issue.
Thanks
Hi , @sartys
As I understand it, you can try to go into your dataflow first and check whether each table can return data correctly and whether there is an error.
If no error is reported, you can try refreshing the dataflow to rule out whether there is a problem with the dataflow or the pipeline.
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.