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

 

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

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'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.