Forum Discussion

Riley Hale's avatar
Riley Hale
Brass Contributor
Jan 06, 2017

Excel File with Data Model in SharePoint Online

I’ve been working to move a lot of my Excel reports to SharePoint from our file shares and have our users interact with them either directly through Excel online.  A lot of my reports contain data th...
power bi
sharepoint
Cyrus Christian's avatar
Cyrus Christian
Brass Contributor
Jan 13, 2017

I see you are with the University of Wisconsin?  Is your Office 365 tenant in the govt Cloud?  I found out the hard way that Data models in Excel ARE NOT supported in the govt space as this feature was never ported to that build.  double check with MS Support to verify but this was my expereince back when I worked for the govt.  So much better working the private sector where I can actually use new technology! :) 

  • Techresa's avatar
    Techresa
    Brass Contributor
    Jan 19, 2017

    Riley, I've heard the same thing about govt tenants that Cyrus mentioned. However, are both your test and production tenants in the govt cloud? Were they created at the same time? 

    • Riley Hale's avatar
      Riley Hale
      Brass Contributor
      Jan 23, 2017

      I don't believe that we are in the government cloud.  We did find that this is indeed related to enabling Preview Features in the SharePoint Admin portal.  This is a known issue, and I don't know when it will be available without enabling Preview Features:

       

      https://answers.microsoft.com/en-us/msoffice/forum/msoffice_sharepoint-mso_winother/sharepoint-online-excel-bi-improvments/b43eb0e8-9fcd-4c6d-829f-e709788c0763

       

      Thanks for following up though. 

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Jan 23, 2017

        Riley, thank you for the link, i missed that Preview Feature.

Resources