Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

vtalvard

BUG - a dataflow working in PROD but not working in DEV after reloading the JSON file

Submitted by on ‎11-16-2022 02:47 AM

Hello, 

 

I am working on a Premium workspace with 3 environments, DEV, TEST and PROD and I use pipeline to deploy from 1 environment to the other. I have a dataflow that was working fine, I deployed it in TEST and PROD a while ago several times, and it was working everywhere.

Recently I made a change in the DEV dataflow, it worked and was refreshing fine, so I deployed in TEST with the pipeline but I got the error "Error: On-Prem execution not supported for entity ..." when I refreshed in TEST. I tried to make some corrections, but as I was not able to correct it, I decided to go back to the original version and start again. So I exported the .JSON file of the dataflow from PROD and reloaded it as new in DEV. And surprise, I now get the error "Error: On-Prem execution not supported for entity ..." in DEV but not in PROD ! It is still refreshing fine in PROD and they are supposed to be exactly the same.

Can anyone explain me what is wrong and how I can solve this ? 

The dataflow is quite complex, is is getting forecast data from 4 different sources, making transformations and then merging them into 2 tables, I was just changing some transformations in DEV, the tables are all in PROD.

 

Thanks for your help !

Best regards

Status: Needs Info
See more ideas labeled with:
2 Comments (2 New)
Comments
Anonymous
Not applicable
‎11-17-2022 01:03 AM

Hi @vtalvard 

What is the change you made in DEV dataflow ? Can you explain it in detail ? 

 

Best Regards,
Community Support Team _ Ailsa Tao

vtalvard
Regular Visitor
‎11-17-2022 05:40 AM

Hello,

 

I have 2 main changes in progress : 1 company of the group is stopping to use one ERP and starting a new one, so it is adding filters to say "get forecast for this company in this table before week 46 and in this other table from week 46" . Second changes is because we are adding data from a new ERP, so it is to udpate some columns that don't have the same taxonomy as the others or create new columns like "year*100+week" to get "2002246" for example. But these changes, I can manage.

My question is why the json file from PROD does not work in DEV when I updload it as a new dataflow and give the message "Error: On-Prem execution not supported for entity..." that does not happen in PROD. 

Thanks

Best regards

Idea Statuses