Dashboard and report from ODS instead of Database

[Amjad1002]

Hello Folks,

I want to know what is the pro and cons for using ODS for Power report and dashboard instead of using Databased such as Teradata etc?

Thanks

[v-stephen-msft · Accepted solution]

Hi @Amjad1002 ,

The pros and cons of a connection often depend on the connection mode in which you connect to a data source. In Power BI Desktop, there are three connection modes, Import mode, DirectQuery mode, and Live Connection. The pros and cons of these three can be referred to:

Power BI Connection Types: DirectQuery, Live, or Import? Tough Decision! - RADACAD

You can check what your connection mode is as follows. Place the mouse over the data.

Best Regards,

Stephen Tao

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