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.

Leandro

PowerBI Publisher Issue on office 365 after update of office

Submitted by Advocate I on ‎10-03-2017 11:02 AM

The new update of the office 365 has an issue with power bi publisher, after the last update, i can no longer conect to a data model!!!

This is only on the office 365, people of my comany who works on office 2013 can conect with no problems!

Status: Accepted
See more ideas labeled with:
10 Comments (10 New)
Comments
Vicky_Song
Impactful Individual
Impactful Individual
‎10-03-2017 11:33 PM
Status changed to: Accepted
 
v-haibl-msft
Employee
Employee
‎10-03-2017 11:34 PM

@Leandro

 

I can repro the same issue as you. I’ve reported it internally to Power BI Team: CRI 48799786
I’ll post here once I get any update about it.

 

Best Regards,
Herbert

Leandro
Advocate I
Advocate I
‎10-04-2017 07:59 AM

Thanks for the help @v-haibl-msft !

 

 

 

v-haibl-msft
Employee
Employee
‎10-10-2017 06:58 PM

@Leandro

 

I’ve got response from the Product Team.

 

We are aware of and will be fixed on our next release of the addin. no ETA for now.

The workaround is tricky, please use the "Analyze in excel" from Power BI portal for now.

If the user still wants a workaround from excel please follow the below steps after tries to analyze some dataset.

attached a photo to help with the steps

  1. go to the Insert tab
  2. click pivot table
  3. choose "Use an external data source" and then "Choose connection" button
  4. right click on the connection, it should be "Power BI - <dataset name>"
  5. click "Edit Connection properties"
  6. go to Definition tab
  7. on the start of the connection string there is "MSOLAP.7" please change it to "MSOLAP" (remove the ".7")
  8. click ok => open => ok

 workaround steps.jpg

 

Best Regards,
Herbert

jnl0006
New Member
‎10-26-2017 09:10 AM

Hi - The solution worked for me, but I'd like to understand what the timetable is for the issue to be resolved. An update here would be much appreciated.

 

 

 

v-haibl-msft
Employee
Employee
‎10-31-2017 08:07 PM

@jnl0006

 

I haven't got specific ETA for this issue now.

 

Best Regards,
Herbert

gh_de
Frequent Visitor
‎11-03-2017 01:06 AM

Seems to work with the newest update available in the web interface ("Analyze in Excel Updates"). I needed to uninstall old OLE DB.

Leandro
Advocate I
Advocate I
‎11-17-2017 05:15 AM

More than a  month after my employers keep without access  to their files and i'm handle a suck pressure here because microsoft no just doesn't fix, but don't even give a F### ETA.

 

I'ts a shame!!!!

I trusted your product, and i have no support after MS **bleep**ed up with this.

aflores
Frequent Visitor
‎06-22-2018 08:09 AM

I Created an excel connected to my Power BI report. The problem I have is that for some columns, the numbers in the excel don't match. I have no clue on what is going on.

 

Any Ideas?

ikasudiarto
New Member
‎09-03-2019 08:42 PM

Hi all,

Is there any information or update that Power BI can get data from excel 365 ? Thank you

 

Regards,

Ika Sudiarto

Idea Statuses