Forum Discussion
Dataflow deploy in pipeline error
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
:
- Activity ID8d455be7-4637-4205-8886-a11f1cbb4f5b
- Request IDf334d0b5-4b67-8c59-eabe-34b17ae38c90
- Correlation ID2e498fb1-0c1a-493e-1f35-8b06f1dd606e
- TimeMon Mar 27 2023 14:29:39 GMT+0200 (Central European Summer Time)
- Service version13.0.20342.55
- Client version2303.3.12949-train
- Cluster URIhttps://wabi-us-north-central-d-primary-redirect.analysis.windows.net/
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 ?
6 Replies
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 LearnCreate 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
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
