Forum Discussion
Helper IIWe cannot convert the value "[Table]" to type Table.
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
Helper IIAnonymous 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.
- Molotch
Too bad, did you file a support ticket? So far I'm quite sure it has something to do with the worst concept in programming since null, Source isolation, ie formula.firewall.
- No I did not, but I have been in direct contact with Power BI support engineers over mail, but after numerous experiments, they supposedly gave up and stopped replying - so I chose an alternate route.
- Molotch
After alot of testing I figured out it indeed was the combining sources that threw the error message in the service but not in the desktop.
My source queries returned Excel workbooks which are tables containing som info with nested tables. This is apparently not enough for PowerBI, you have to return the specific table in a query on it's own if you want to combine them, ie unnest the nested tables each one in it's own source query.