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

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.

6 Replies

  • 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