cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cclark01 Frequent Visitor
Frequent Visitor

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:

2017-07-13_16-02-01.png

 

Thanks in advance for the help!

2 REPLIES 2
Super User
Super User

Re: Web Portal refresh is giving error: We cannot convert the value "[Table]" to type Tabl

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.

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog
cclark01 Frequent Visitor
Frequent Visitor

Re: Web Portal refresh is giving error: We cannot convert the value "[Table]" to type Tabl

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.

 

 

 

 

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)