Forum Discussion

MI's avatar
MI
Frequent Visitor
4 years ago
Solved

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 i...
Server Error
  • MI's avatar
    MI
    4 years ago

    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 

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

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

  • MI's avatar
    MI
    Frequent Visitor
    4 years ago

    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

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      4 years ago

      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's avatar
        MI
        Frequent Visitor
        4 years ago

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

Related content