Forum Discussion
Web Portal refresh is giving error: We cannot convert the value "[Table]" to type Table
I am trying to refresh my dataset on the web portal, but anytime I schedule a refresh or try refresh now, it returns the error: We cannot convert the value "[Table]" to type Table
The file refreshed fine everytime in the pbix file, but never works once it is published. It uses an excel file from a SharePoint site and a query from an Oracle database. I have experimented with changing the security levels for both of the sources but haven't had any luck. I have also tried taking the file down, then republishing, but still no luck.
Here is a screenshot of what I am getting:
Thanks in advance for the help!
2 Replies
- Hi there
Could I suggest if you had to open your PBIX file, and then file Save As. To see if this will save it as a newer version of the PBIX file.
I have had an issue in the past where the PBIX file was in an older format and the data would not refresh from Power BI Service.
My work around is that I created a new PBIX file in a newer version of Power BI Desktop and then ported all the data across using the ZIP method (which shows the contents of the PBIX file) and then copied it into the new Power BI Desktop file.I tried the "Save As" method but I am still getting the same result.
I'm not quite sure what you mean with the Zip method.
