Forum Discussion

heathernicole's avatar
heathernicole
Icon for Continued Contributor rankContinued Contributor
8 years ago

Cannot connect to the mashup data source. The column 'field_name' of the table wasn't found.

I have been having issues with this one particular report. Here is the full error message:   Last refresh failed: Wed Dec 27 2017 06:37:50 GMT-0500 (Eastern Standard Time)  Cannot connect to the m...
Need Help
heathernicole's avatar
heathernicole
Icon for Continued Contributor rankContinued Contributor
8 years ago

v-yulgu-msft - Thanks for the response! :)

 

I'm already manually refreshing the powerpivot file - and then refreshing the Power BI file and THEN pushing to the service. 

 

But that really isn't a practical setup. If the field names have been changed in the PowerPivot workbook and were pulled into Power BI like - it doesn't make sense that Power BI would still be searching for the original file names. 

 

Maybe I'm not understanding what it's doing in the background - but if the field names change - it would make sense for that to carry over. It just doesn't make sense. 

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi heathernicole,

 

I agree with you that the field name should be covered once it is changed in source data. You could submit this feature request at ideas page. Thanks for your feedback. You could paste the link back and I can vote it up for you.

 

Regards,

Yuliana Gu