cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MI
Frequent Visitor

We cannot convert the value "[Table]" to type Table.

Hi,

I donot face any error in Power BI Desktop. but while running same report on server, I face below error. Waiting for support.

 

 

We cannot convert the value "[Table]" to type Table.

 Here is the M query. 

let
Source = Folder.Files("\\IPACK-SVR-FILE\Production\10-Waste\Employee of the Month"),
RemoveOtherColumns = Table.SelectColumns(Source,{"Content", "Name"}),
SplitTextFunction = Splitter.SplitTextByRepeatedLengths(30000),
ListInput = Table.ToRows(RemoveOtherColumns),
ConvertOneFile = (InputRow as list) =>
let
BinaryIn = InputRow{0},
FileName = InputRow{1},
BinaryText = Binary.ToText(BinaryIn, BinaryEncoding.Base64),
SplitUpText = SplitTextFunction(BinaryText),
AddFileName = List.Transform(SplitUpText, each {FileName,_})
in
AddFileName,
ConvertAllFiles = List.Transform(ListInput, each ConvertOneFile(_)),
CombineLists = List.Combine(ConvertAllFiles),
ToTable = #table(type table[Name=text,Pic=text],CombineLists),
AddIndexColumn = Table.AddIndexColumn(ToTable, "Index", 0, 1),
#"Filtered Rows" = Table.SelectRows(AddIndexColumn, each ([Name] <> "Thumbs.db")),
#"Split Column by Delimiter" = Table.SplitColumn(#"Filtered Rows", "Name", Splitter.SplitTextByDelimiter(".", QuoteStyle.Csv), {"Name.1", "Name.2"}),
#"Changed Type" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Name.1", type text}, {"Name.2", type text}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"Name.2"}),
#"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"Name.1", "Name"}})
in
#"Renamed Columns"

1 ACCEPTED SOLUTION
MI
Frequent Visitor

Dear Ibendlin,

Thank you for your support. I have found the solution for this problem. actually issue was with Privacy setting of the data source. after fix this my problem is resolved. Thank u 

View solution in original post

7 REPLIES 7
v-henryk-mstf
Community Support
Community Support

Hi @MI ,

 

If the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.


Looking forward to your feedback.🙂


Best Regards,
Henry

lbendlin
Super User
Super User

Are there any empty (zero length) files in that folder?  Or files that are being written to while you run your query?

MI
Frequent Visitor

Hi,

No, there is no empty (zero length) files in that folder. attached query converts high resolution Pictures to display in BI. This works perfect in Desktop but gives error on server

Does it fail completely in the service or only for certain files?  What's the average size of the image files, and how many are there?

MI
Frequent Visitor

It's failing completely. There are 5 files with average size of each file is 450 Kb

What gateway version are you using? Can the gateway VMs see the file share? Do you have an option to put the files on a sharepoint or Onedrive instead?

MI
Frequent Visitor

Dear Ibendlin,

Thank you for your support. I have found the solution for this problem. actually issue was with Privacy setting of the data source. after fix this my problem is resolved. Thank u 

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!