How to get real time data in power BI without using data gateway ?

[AnandRanga]

Hello all,

I am  creating a dashboard with database that is hosted on Azure, in this case I cant install Data Gateway as it is not server where I can install data gateway. 

In this case how can I setup daily refresh schedule. So that dashboard can show the current data.

I have setup a dataset in PowerBI via Azure, that is sending data real time but my problem is I cant do much data transformation in online app of Power BI. Is it possible to create dashboard on Power BI desktop and then publish it on web with live dataset.

Please provide some link also if possible.

Thanks for your time.

@Vvelarde

[v-ljerr-msft]

Hi @AnandRanga,

We don't need a gateway for cloud data sources like Azure SQL Database. The service will be able to connect to that data source without a gateway. For more details, you can refer to this article.

Regards

[AnandRanga]

@v-ljerr-msft

Thanks a lot for your reply.

Actually I am using Azure real time streaming job and connecting power BI online and it's working fine with that but I cant transform data in power BI online as there is no option for data modeling in power BI online. 

When I create dashboard in power BI desktop and deploy it on web It doesn't get refreshed. So my question is:

1) Is it possible to create dashboard in power BI desktop using Azure database credentials and then deploy it on web and get it refreshed in every 10 seconds.

2) Is it possible to transform the data or a bit of data modeling in poewr BI online OR we have to send transformed data from Azure itself ?

I have also used direct query but it works when I reload the page.

Thanks for your time.

[VigneshNadar]

Did you find a way to solve your problem?