Power Query, Combine Files, Unexpected Error, Mashup Text

[Anonymous]

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

[Anonymous]

Hi @Anonymous ,

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

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

Best Regards,
Eyelyn Qin

[crystalLearn]

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]

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!

[Anonymous]

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.