Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Advance Editor Query Copy Paste Error and SQL Dumper EXE error

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 Sal...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    8 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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's avatar
v-qiuyu-msft
Community Support
8 years ago

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's avatar
    Anonymous
    Not applicable
    8 years ago

    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.