Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

yoshihirok

Issue: After import Excel book contents, visuals do not move/scale

Submitted by Post Prodigy on ‎03-25-2017 05:02 PM

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.

1.png

 

 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

 

 

 

Status: Accepted
See more ideas labeled with:
7 Comments (7 New)
Comments
v-haibl-msft
Employee
Employee
‎03-27-2017 02:45 AM

@yoshihirok

 

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
Impactful Individual
‎03-27-2017 02:45 AM
Status changed to: Accepted
 
yoshihirok
Post Prodigy
Post Prodigy
‎03-27-2017 02:48 AM

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

rrosendahl
Frequent Visitor
‎03-27-2017 04:32 AM

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
Post Prodigy
‎03-28-2017 04:29 AM

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_storm
New Member
‎03-28-2017 06:48 AM

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
Post Prodigy
‎03-28-2017 10:39 AM

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

Idea Statuses