Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
for the last two days I've having problems with one of our connections. We get an "error occurred while processing the data in the dataset."
The details of the error says "The parameter is expected to be of type Text.Type or Binary.Type."
Does anyone know what's wrong and what to do to solve the problem?
I solved this by clicking the query, then selecting the source on the right and then selecting the navigation. Wait for the preview to load and then re-do the process for each query where there is a exclamation next to it. Close and Apply.
I have this issue too. So I did a file compare of the source files of when it worked last week and the refreshed source files this week and found that somehow 3 of the files had corrupted data, basically it was missing the KEY field in the first record.
I edited the 3 files and I no longer recieve the error.
For me the issue was with the data not the connection.
hope that helps.
I had the same issue, so i tried to recreate the file from the begining and compared the M query and steps in the new file and file with error.
The scenario I was is of source is type of "Folder" and when I went to Transform Data/ Edit Queries window, I double clicked on the File which was shown in queries section named as "Sample file" this created additional steps and corrupted the next parameter step.
So I would suggest make sure the parameter is working and it has pointing to the right column.
When you click on "Sample File" in Queries section it should have only two applied steps Source and Navigation.
attached screenshot might give you a reference
Hope this would help some one
I know this is late :), but I just experienced this and thought I'd explain what happened in my case. I was tweaking a package to create dynamic, parameter driven folder paths for the Folder Connector. Finally got all of the parts working, Individual file queries were accepting the new paths, but the "Transform Sample File" was throwing the error mentioned by the OP. In my case, the error looked like this:
The file had somehow lost attributes of the Sample File Parameter. Note the Suggested and Default values are incorrect:
The only required change was to reset the Suggested Values to Binary and the Default and Current values to the "Sample File".
I followed your steps and resolved the issue, big thank you to your comments!
I felt the "Sample File Parameter" should be allowed to hidden away @PowerBI team.
I don't know if this will help anyone two years later, but I also encountered this error and was able to fix it.
For me the error came from some html that I was parsing using the 'parse xml' command from the toolbar. There were some nulls in my dataset which generated the error when the parsing was attempted. My work around was to replace the null values with an empty structure "<div></div>" which was then parsed and returned a null value correctly
Which step is producing this error? Are you connecting to a folder?
Facing the same issue, how can this be fixed?
Can Anyone Please Help for the Error
I recently rebuilt my pc and now I am getting this issue "The parameter is expected to be of type Text.Type or Binary.Type." on refresh which previously worked fine for months.
The error occurs after I have merged to existing tables (they have no errors) and I try to expand out the columns.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |