Forum Discussion

powerdell's avatar
powerdell
Regular Visitor
3 years ago

PowerBI DataSet from Excel (Live Connection) data model

Hello,   I am fairly new to all this although have been a developer for many years. My scenario is I have a SharePoint (Teams folder) Excel spreadsheet with 2 key tables.  I managed to create...
Need Help
powerdell's avatar
powerdell
Regular Visitor
3 years ago

I just wanted to update for anybody reading this, it is not possible.

Yes that is right, it is not possible to create a spreadsheet hosted in O365, use it as a live data source in PowerBI AND create a calculated column or do any data modelling (apart from create a Measure).

The only way it seems is to create a PowerBI gateway, host the document on... yea exactly, completely impractical. 

If anybody from Microsoft or the PowerBI team is reading please do consider implementing this feature, to me it seems fairly basic and not that technically challenging to accomplish. The fact it is possible if I hosted the file on a fileserver and used an Application Gateway and refresh schedule is a pretty clear indication this should be implemented for SharePoint/O365 hosted files.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi powerdell ,

Thanks for your sharing. For the feture which you referred, you can submit a new idea on the ideas site. It is a place for customers provide feedback about Microsoft Office products . What's more, if feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

Best Regards