Forum Discussion

User0201_1's avatar
User0201_1
New Member
2 years ago
Solved

Power Bi Schedule Refresh

Hello Team,   I have created a dashboard using import mode with 5 private Google Sheets & ODBC. The data source is ODBC, and we used a replica of the large database. The dashboard is published on t...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi User0201_1 

     

    Issue 1:

    Ensure that the ODBC data source is correctly configured in your system. This includes checking the DSN settings and ensuring that the correct drivers are installed.

    Please refer to this document:

    Power Query ODBC connector - Power Query | Microsoft Learn

    If you're using an on-premises data gateway, ensure that it's correctly configured and running. The gateway needs to be online and accessible by Power BI to refresh the data.

    On-premises data gateway - Power BI | Microsoft Learn

     

    Issue 2:

    Try re-entering the credentials for the data sources in Power BI Service. Go to the dataset settings, and under the Data source credentials, update the credentials again, ensuring that the option to skip the test connection is not s
    Ensure that the credentials are correctly encrypted and stored. This might involve checking the gateway's configuration or how the credentials are managed in Power BI Service.elected.

    Configure credentials programmatically for Power BI embedded analytics - Power BI | Microsoft Learn

     

    Best Regards

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