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

[Ronnie7]

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!

[Anonymous]

OMG, this is it. This was my case - I used a mix of Sharepoint sources with a dataflow, and dataflow was set to Private, while all others were Organizational.

[Anonymous]

Thanks Erik, I tried that when the problem ovcured initially, but in my case that did not solve the problem.

[edhans]

Same error here. SQL Server on prem via gateway with one Excel file in Sharepoint.

• Tried setting perms to Organizational for all of them. No good.
• Nothing is nested. It is a very simple set of tables and queries with a final join at the end to bring in the Excel data into the last query step.
• Removing from the Power BI Service and republishing did nothing (other than mess up associated Flows 😕 )
• As of right now, it is stuck in a perpetual refresh. Normally takes under a minute. Now at 12 and counting. I'll jsut have to wait and see what happens later.

All that to say, mashups with Sharepoint don't seem to have been thoroughly debuged.

It is too bad we cannot link directly to a file on sharepoint via the file URL vs having to go to the sharepoint directory, then drill down to the file with filters. Not sure it would fix this issue, but it might, and would definitely make my life easier.

[Ronnie7]

Anyone?

[Ronnie7]

Help please