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

ArthurBraga's avatar
ArthurBraga
New Member
2 months ago

Hi!

 

I had the same issue, then i asked AI and the answer that i got was "This is an error in PowerQuery (M) you need to check all queries that have this: Table.ColumnNames(KeepCols{0}[Data])".

 

But searching in forums, i tried to put the same privacy levels at Desktop and Service:

Desktop:

Transform Data > Data Source Settings > Privacy

Service: 

Semantic Model Settings > Data Source Credentials.

 

I hope this help you 🙂

Related content