Forum Discussion

arveseba's avatar
arveseba
Frequent Visitor
9 years ago
Solved

Query from internal server.

I need refreshing dashboard on powerbi. I have in excel file query from internal server, where access for this report is only in corporate network. I copied this excel file to onedrive business, con...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi arveseba,

    As I tested, if you sync OneDrive for Business with your local cimputer. Whenever you're online, any changes of the excel fine that you make will sync automatically. In Power BI service, please click Get Data->files->onedrive for business->select the file, when you can create schedule refresh, turn on the refresh buttom(please see the button highlghted in blue line), the dataset will refresh one hour without gateway.



    Best Regards,
    Angelia

Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

Oh, yeah, that's not going to work. You need a gateway or you need to ship the data from the internal server up into the cloud.

arveseba's avatar
arveseba
Frequent Visitor
9 years ago

I know about. But if i ship the data like this:

Internal Server>local file in PC (connected in corporate network) -> one drive businness.

 

Maybe this solution work?

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    9 years ago

    Hi arveseba,

    As I tested, if you sync OneDrive for Business with your local cimputer. Whenever you're online, any changes of the excel fine that you make will sync automatically. In Power BI service, please click Get Data->files->onedrive for business->select the file, when you can create schedule refresh, turn on the refresh buttom(please see the button highlghted in blue line), the dataset will refresh one hour without gateway.



    Best Regards,
    Angelia