Issue: After import Excel book contents, visuals do not move/scale
Power BI Desktop Issue: Visuals do not move and scale and remove after Importing Excel book contents.
When select the visual, any handle for move/resize is not exist.
Re-produce step:
1. Create a Excel file
2. Create a Data model in the Excel.
3. Import the Excel file to Power BI Desktop
4. Create a visual
I want to convert my report from Excel file to Power BI Desktop.
Regards,
Yoshihiro Kawabata
7 Comments
- v-haibl-msft
Microsoft Employee
I've already reported it internally to Power BI Team: CRI 33923598
I'll post here once I get any update about it.You can save the PBIX file and reopen it to workaround this issue.
Best Regards,
Herbert - Vicky_Song
Impactful Individual
Status changed:NewtoAccepted - yoshihirok
Post Prodigy
Hi v-haibl-msft thank you for report and workaround.
I'm waiting updating about this issue.
and I'm tring the workaround / save-reopen pbix
Regards,
Yoshihiro Kawabata
- rrosendahlFrequent Visitor
Hi Yoshihirok,
I got the exact same thing today.. and I still don't know why it happends. Hope that there will be a answer from Microsoft. I used the following workaround: Just delete one of the relationships between tables (in Power BI desktop) that you've made in your Excel file. Create this relationship again (in Power BI Desktop).
After making the new (but same) relation you should be able to move and resize your visuals.
Got a feeling that the full Excel datamodel freezes Power BI Desktop, for what ever reason...
Hope it helps.
Kind Regards,
- yoshihirok
Post Prodigy
Hi rrosendahl thank you to the workaround of deleting-recreate relationship.
The workaround of save-reopen pbix file does work well.
I can continue my work after import from Excel.
now, I'm contiuning updating this issue from microsoft.
Regards,
Yoshihiro Kawabata
- dj_stormNew Member
Glad I found this, as I just posted something very similar. I dont have an relationships setup in my model, but I will attempt to save and reopen the file. I am not able to resize the visual either.
- yoshihirok
Post Prodigy
Hi, dj_storm, thank you for your reply.
"I am not able to resize the visual either" seems to need another workaround for this issue.
I'm waiting for update from Microsoft.
Regards,
Yoshihiro Kawabata