Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
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?
Regards
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.
Same error here. SQL Server on prem via gateway with one Excel file in Sharepoint.
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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingAnyone?
Help please
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.