Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Power Query, Combine Files, Unexpected Error, Mashup Text

Hello Community, 

I have been using a transformation sequence to combine a number of .cvs file, everything had been working well. About two weeks ago I got an 'Unxpected Error' and a Mashup Text prompt when making slight adjustment to the query. I tried to go back to my previous query editor code but am still getting the same error. 

 

Any thoughts on this are much appreciated!!

 

 

 

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

     

    I found a similar submitted issue which is about Unable to create a dataflow connected to OracleInternal ICM ID: 292582724

    Please be patient to wait for fixing. If there is any news, I will update it here.


    Best Regards,
    Eyelyn Qin

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

     

    1.make sure your PBI is the latest version.

    2.Please go to Power Query Editor to see if there are any errors in the underlying M code.

    3.Go to the Data source settings, clear the permissions and re-connect

     

    Similar thread:

    https://community.powerbi.com/t5/Service/we-encountered-an-unexpected-Error-when-opening-a-dataflow/m-p/1940367

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Today I have the same issue, last week was everything ok with the same setting...

    Anonymous do you still have the same problem? would be interesting to know how did you solve it.

    evelyn91011 

    your proposed step 1: since I'm trying to connect several files to a dataflow, so it is directly in the PowerBI WorkingSpace, so assume not  relevant to my case.

    your proposed step 2: how to check ?

    your proposed step 3: it has been working, so assume not  relevant to my case.

    • Anonymous's avatar
      Anonymous
      Not applicable

      I still have no resolution to this issue. This is a Dataflow issue in our workspace. All queries we have that use the 'combine files' have the issue.

      Again any help is appreciated!