Forum Discussion

uthall's avatar
uthall
Icon for Helper II rankHelper II
7 years ago

Accessing Online Data

Hi,   I have a MariaDB database installed on a server hosted in the cloud.   I have a report generated on Power BI desktop, and when i publish this report to the cloud, access to this database is...
Need Help
v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi uthall ,

Actually, you could install the on-premises gateway on the device which you installed the Power BI Desktop, but we will recommend installing the gateway on a device that can run all the time.

In addition, if your data source is online, we could not configure the gateway and it will refresh automatically.

For your requirement, I'm afraid that you may export your data in the online platform which is free such as OneDrive bussiness and then get data in Power BI Desktop.

If you're good at coding, you may create the API by yourself.

From my point, I think use gateway is the most effective for your scenario.

Best Regards,

Cherry

 

  • uthall's avatar
    uthall
    Icon for Helper II rankHelper II
    7 years ago

    Hi Cherry,

     

    So you reccomend i use a gateway?

     

    Can a gateway allow me realtime updates, or at least 60 second updates?

     

    What platform will allow me direct databse connections without a gateway in powerbi, it seems only Azure warehouse is available?

     

    I have access to PowerBI Server, is that also an option?

     

    Thanks

    Jeff