Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Cj
New Member

The parameter is expected to be of type Text.Type or Binary.Type.

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?

10 REPLIES 10
VishaalPatel
Regular Visitor

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. 

rlwheelwright
New Member

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.

stunuguntla
Frequent Visitor

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

 

powerBI.png 

 

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:

2021-04-05_6-33-47.jpg

 

The file had somehow lost attributes of the Sample File Parameter.  Note the Suggested and Default values are incorrect:

dwainew_0-1617631069241.pngdwainew_1-1617631121201.png

 

The only required change was to reset the Suggested Values to Binary and the Default and Current values to the "Sample File".

dwainew_2-1617631234444.png

 

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. 

gev432
Regular Visitor

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

drewlewis15
Solution Specialist
Solution Specialist

Which step is producing this error?  Are you connecting to a folder?

Facing the same issue, how can this be fixed?

 

apoorva
New Member

Can Anyone Please Help for the Error

Anaplex
Frequent Visitor

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.

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.