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

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