Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Use Power BI as Data Source for Excel and Utilize Data Gateway

GOAL: Refresh Excel data in SharePoint Online through Excel in web part or Excel Services web page (not opening in Excel client) connected to on-premises data source.   I have set up a Data Gateway...
Chip_Chipperson's avatar
Chip_Chipperson
Frequent Visitor
9 years ago

Did anything come from this? 

We are trying to use the data gateway in our local Excel workbooks, and have the same workbooks seamlessly use the data gateway after being published to Power BI. Is this possible? I think our question/problem is similar. 

Hikmer's avatar
Hikmer
Microsoft Employee
9 years ago

I have the same question, it works with PowerPivot but so far not with a driect conenction in Excel.  I'll open a ticket to verify.

  • Hikmer's avatar
    Hikmer
    Microsoft Employee
    9 years ago

    From my ticket with Microsoft, the only two ways to connect an Excel file to live data using the gateway is via PowerPivot and PowerQuery (now called GetData in excel).  However, the PowerQuery option is limited to a 10MB file...so both these options are useless to me.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi Hikmer,

      may you be able to share the MSticket number to me? 

      You have also no update on this? So the clarify my understanding: the statement from MS is that it's NOT possible to publish a excel workbook to 0365 which uses a live-connection to onPrem SSAS Cube, right? I have the same scenario, neither creating the connection directly to onPrem SSAS nor creating a connection to PowerBI.com ("Analyse in Excel") worked for me, the "OnPrem Data Gateway" logs show no activitiy, so i assume the gateway is not involved in the "Live" Request...

      I will now try with an AzureAS Cube instead of onPrem SSAS datasource, but i'm afraid that will also not work :(

      Greetings,

      Jochen