Forum Discussion
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 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!
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
27 Replies
These days I got the same error.
Apparently what caused this error was that the privacy level configured on Power BI Desktop was diferent of the privacy level of Power BI Service, when I fix that the error disappeared.Its Works! Ajdjust the privacy levelk acordance to security requirements
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!
Anyone?
Help please
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
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!
I have been posting this issue everywhere and didn't get any response at all!
Is there any professional support for powerbi?
Here my issue:
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 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!Are there any other options besides removing the references?
I'm having a similar problem which is causing me a massive headache but the queries are all to SharePoint (online) and all have the same privacy level :smileymad:
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 🙂
