Advance Editor Query Copy Paste Error and SQL Dumper EXE error

[Anonymous]

I have serveral Power BI files with different countries/region. All the files will have the same type of dashboard display but with only diffrent filters and parameters. The source file were from Salesforce report.
I tried copying and pasting the advance editor and it works. However, when I run refresh or close and apply the edit queries, my data were messed up showing all the full set of data. How do I solve this ?

Another issue I have was when I managed the relationship. I received this message called SQL Dumper EXE error black command screen. After that it automatically closes my power BI file. It happens all the time when I tried to connect the relationship from diffrent tables from the same source. 

[v-qiuyu-msft]

Hi @Anonymous,

1. When you refresh, please check which parameter values you already set. As Power Query has filter based on Query Parameter, check if the parameter value actually return full set of data or not. 

2. The issue has been reported before internally, the fix will be released on this month. Please use Manage Relationships to work around the issue. 

 

Best Regards,
Qiuyun Yu 

[Anonymous]

Hi @v-qiuyu-msft

1. Yes when it refresh it retrun full set of data. Which i do not want it to. I need my data to maintain.

2. Ok thank you will wait the fix this month.

[v-qiuyu-msft]

Hi @Anonymous,

Regarding the first issue, I mean please check current Query Parameter value to compare returned data to see if it's expected. 

Also would you please share the issued pbix file with us? If it has sensitive data, you upload pbix file to you OneDrive and send the link to me in private message. 

Best Regards,
Qiuyun Yu 

[Anonymous]

Hi @v-qiuyu-msft

The querey parameter is fine. No issue at all. If I do it manually by repeating adding formula, conditional collumn, format, then it is all fine. The issue only comes when I copy and paste the steps in advance editior.

[v-qiuyu-msft]

Hi @Anonymous,

Please click on Advanced Editor, check if each step in Power Query reference the correct previous steps name like below: 

Also you can compare is there any difference between generated Power Query result from those two ways. 

Best Regards,

Qiuyun Yu 

[Anonymous · Accepted solution]

Yes all the power querey steps were correct. Speculation was one of the file has been corrupted, since copying from other file source is working.