Forum Discussion

Ronnie7's avatar
Ronnie7
Icon for Helper II rankHelper II
9 years ago
Solved

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

Hi, I'm unable to refresh the dataset in PoweBI web app. i get the following error: We cannot convert the value "[Table]" to type Table. My data Source is Odata feed (Project Online) In PowerBI De...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi Ronnie7,

     

    As the issue only occurs on Power BI service, but not on Power BI Desktop, have you tried removing the entire dataset from Power BI service first, then republishing it from Power BI Desktop to see if it works?:smileyhappy:

     

    Regards

Ronnie7's avatar
Ronnie7
Icon for Helper II rankHelper II
9 years ago

Hi,

 

I'm unable to refresh the dataset in PoweBI web app. i get the following error:

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

 

In PowerBI Desktop i have no issues at all and the data is being refreshed. It's only in the web app, it just happened today even though i didn't change anything in the last couple of days.

 

I have seen some posts of people who ran (still running into this issue). This "Combine data" thing is irrelevant as i don't have a gatway... Can anyone please help with that?

 

Thanks!

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Ronnie7,

 

As the issue only occurs on Power BI service, but not on Power BI Desktop, have you tried removing the entire dataset from Power BI service first, then republishing it from Power BI Desktop to see if it works?:smileyhappy:

 

Regards

  • Ronnie7's avatar
    Ronnie7
    Icon for Helper II rankHelper II
    9 years ago

    Worked!

    I tried everything but for some reason didn't think about doing this, cause i thought i would just get the exact same error!

    Phew.. I was so desperate at some point.

     

    Thanks!

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      I am facing this same issue at the moment, Refreshes perfectly fine in Desktop, facing the above error in Service. Tried removing the dataset and republishing multiple times now. Since Desktop works fine, I am having a hard time trouble shooting this... Fails both with scheduled and manual refresh in Service. Sources: SharePoint Online List and Azure SQL DB... 

      • Molotch's avatar
        Molotch
        Icon for Helper II rankHelper II
        8 years ago

        Anonymous Did you ever solve this? I have the same issue and a ticket logged with the support but I'd like to bypass the problem if I can. I have tried removeing the dataset and republish to no avail. I have the source data in Excel workbooks in Sharepoint Online.

    • jmdh's avatar
      jmdh
      Icon for Advocate IV rankAdvocate IV
      7 years ago

      Thanks I Will apply the same for a similar error (cannot convert the value "[Type" ...)

  • Aman890725's avatar
    Aman890725
    New Member
    1 year ago

    I had the same issue and the problem was at some point the permissions for my data sources were defaulted to private, the resolution for this was updating them in the Transform data > Data source settings > Edit Permissions > Privacy Level

Related content