Forum Discussion

DionTN's avatar
DionTN
Helper II
4 years ago
Solved

Unable to add references to datasource

I created a dashboard by integrating MariaDB in the report. The publish is going well, only the automatically refreshing (and refreshing in app.powerbi.com) is failing. 

 

I created a new gateway but can not connect the gateway to my datasource?

 

 

  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi DionTN ,

     

    As far as I know, we need to configure gateway to refresh MariaDB dataset.

    Here I suggest you to install the standard gateway, it supports Direct Query / Live connection connection mode.

    There are five main steps for using a gateway:

    1. Download and install the gateway on a local computer.
    2. Configure the gateway based on your firewall and other network requirements.
    3. Add gateway admins who can also manage and administer other network requirements.
    4. Use the gateway to refresh an on-premises data source.
    5. Troubleshoot issues with the gateway.

    Then configure scheduled refresh in Dataset setting in Power BI Service.

     

    Best Regards,
    Rico Zhou

     

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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi DionTN ,

     

    As far as I know, we need to configure gateway to refresh MariaDB dataset.

    Here I suggest you to install the standard gateway, it supports Direct Query / Live connection connection mode.

    There are five main steps for using a gateway:

    1. Download and install the gateway on a local computer.
    2. Configure the gateway based on your firewall and other network requirements.
    3. Add gateway admins who can also manage and administer other network requirements.
    4. Use the gateway to refresh an on-premises data source.
    5. Troubleshoot issues with the gateway.

    Then configure scheduled refresh in Dataset setting in Power BI Service.

     

    Best Regards,
    Rico Zhou

     

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