Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
Bando
Frequent Visitor

Issue with mixing importing Excel file with getting data from Excel

When I import an Excel file using the import method, to get at a powerPivot table, and then importing data from a second Excel sheet, using the get data method, I have an issue with then editing the query. If I try and transform a column from numerical data to text I get data erros when I then apply this. I've tried loading the second Excel file on it's own and the query edit loads fine.

 

Any Ideas?

4 REPLIES 4
v-qiuyu-msft
Community Support
Community Support

Hi @Bando,

 

I'm not able to reproduce the issue on my side. Which error throws out? Please share detail steps for us to test it.

 

By the way, please try to use the latest desktop version 2.43.4647.541.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi, Thsi morning I've only been able to reproduce the error once after 7 tries. Perhaps the reboot has helped. I've included a screenshot of the error message.

Screengrab.png

 

Hi @Bando,

 

It seems the issue occurs intermittently.  Please click the Error to see detail error message and share it here.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I can't reproduce the error message anymore but the gist of the message was "couldn't convert text to number".

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

Check out the April 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

Find out what's new and trending in the Fabric community.