Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

online automatic refresh powerbi

I got my report done with 2 sources 1 SQL database 1 local excel file my need is just to refresh the sql database, but I can't since the file local excel, powerbi automatic refresh doesn't find th...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    Anonymous ,

     

    I'm afraid schedule refresh is implemented on the whole dataset, not the separated data source. If one of the datasource hasn't been configured correctly(e.g.: gateway), the refresh will fail. You may create two different report based on excel and sql server and refresh them seperately.

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

Anonymous ,

 

I'm afraid schedule refresh is implemented on the whole dataset, not the separated data source. If one of the datasource hasn't been configured correctly(e.g.: gateway), the refresh will fail. You may create two different report based on excel and sql server and refresh them seperately.

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    so there is no way to say to powerBI in query mode just to import this excel file and keep like that without refreshing?

    • v-yuta-msft's avatar
      v-yuta-msft
      Community Support
      7 years ago

      Anonymous ,

       

      Yes, so I would suggest you to create two datasets and configure schedule refresh to the database.

       

      Community Support Team _ Jimmy Tao

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.