Forum Discussion

cwilsonLUR's avatar
cwilsonLUR
Frequent Visitor
3 years ago
Solved

Schedule Refresh

Hello,   I have been trying to scheduele a refresh for my dasboard reports for a few days now. I know that the issue is because I did not enter a data source credentials when i was first uploading ...
Dataflow
Need Help
Tutorial Requests
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    Hi, cwilsonLUR 

    The "Data Source credential" is always used for the data source in the cloud instead of on-premise.

    According to your screenshot, you can see that your data source is xlsx, the first thing to confirm is whether your xlsx is from your local computer, if so, you need to download the local data gateway to interact with your local computer resources.

    An on-premises data gateway is a bridge for cloud interaction with on-premises.

    You can download it in this website:

     

    Power BI Gateway | Microsoft Power BI

    For more information, you can refer to :

    On-premises data gateway - Power BI | Microsoft Learn

     

    And you need to configure the each .xlsx credential in this gateway, the detailed steps you can refer to :
    Add or remove a gateway data source - Power BI | Microsoft Learn

     

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

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

v-yueyunzh-msft's avatar
v-yueyunzh-msft
Community Support
3 years ago

Hi , cwilsonLUR 

As far as I know, according to the screenshot of the error you have provided so far, the problem you are experiencing is caused by the lack of configuration and the definition of the data source credentials you entered for this dataset, so you need to go to the "Data Source credentials" to find the data source that shows the "×" icon on the right, and click "Edit credential" to enter the corresponding credentials for them, let the data source definition take effect, and check whether the refresh was successful again:

For a detailed explanation and description of this procedure, please check this official document:

How to configure Power BI report scheduled refresh - Power BI | Microsoft Learn

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

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