Forum Discussion

MatWebb's avatar
MatWebb
Advocate I
10 years ago
Solved

Azure Table source with On Premises Gateway

Hi All, hoping someone here has had this problem too and can shed some light as to a solution:   I have a PBIX file that has 10 file or folder data sources - when uploaded to the online service and...
Need Help
  • v-micsh-msft's avatar
    v-micsh-msft
    10 years ago

    MatWebb,

     

    Currently Online data sources and Data sources On Premises Gateway can’t work together, the workaround is to take use of Personal gateway to combine on-premises with online data sources.

    Please take a moment to check and vote the Idea below:

    Combine enterprise gateway and online data sources

     

    Quoted the response from Dimah Zaidalkilani (Admin, Microsoft Power BI) Jun 21, 2016:

    “

    Thanks for suggestion this and all your comments. We’ve added this feature to our backlog but can’t share an ETA on when it’ll be delivered for now.
    The current workaround we’ve been suggesting is to use the personal gateway to combine on-prem with online data sources.
    I’ll update the status once this work has started. Meanwhile, keep voting and adding other ideas to improve the gateway.

    ”

    Regarding additional information about Data refresh, please check:

    Data refresh in Power BI

    If any further help needed, please feel free to post back.

    Regards

     

Anonymous's avatar
Anonymous
Not applicable
10 years ago

MatWebb Can't find the specifics of what I thought I read. But based on the documentation on the refresh page this conflict doesn't seem surprising since you can't manually configure refresh for Azure SQL DB...

source

I'm hesitant to say this can't be done, because I can't find a clear statement pertaining to that. Have you tried moving your PBIX to a OneDrive location? Maybe pushing that up would enable the refresh...