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.

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
8 years ago

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