Real time Reporting

[AparnaJ]

Hi,

We have a need to connect to SQL server and do real time reporting from Power BI, Can you suggest if this is possible? Or any other options.

Thank you.

Aparna

[v-robertq-msft · Accepted solution]

Hi, 

According to your description, I think you can try to use the Direct query mode to connect to the SQL Server to do a real-time reporting from Power BI:

You can refer to these links:

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

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