Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
DionTN
Helper II
Helper II

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. 

 

DionTN_0-1661324318607.png

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

DionTN_1-1661324444228.png

 

DionTN_2-1661324490617.png

 

1 ACCEPTED SOLUTION
v-rzhou-msft
Community Support
Community Support

Hi @DionTN ,

 

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

RicoZhou_0-1661762650526.png

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.

View solution in original post

1 REPLY 1
v-rzhou-msft
Community Support
Community Support

Hi @DionTN ,

 

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

RicoZhou_0-1661762650526.png

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.