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 

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

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

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

Related content