Solved: refresh report from database

sn123 · ‎01-08-2018

Hi,

I am creating a model BI environment for our Oracle database on Power BI Desktop.

Every time I add a table, it refreshes the data if it is not restricted by query.

And data for all tables in the model seems to be stored in the Power BI desktop to run the reports.

Is it possible to create a data model such that every time a report is run, data is obtained from the database ?

We have a very large Data warehouse on which we run reports along with some live databases, having data duplicated on a report server seems excessive.

Thanks

Sushma

v-chuncz-msft · ‎01-08-2018

@sn123,

You may select DirectQuery mode when connecting.

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

Community Support Team _ Sam Zha
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

v-chuncz-msft · ‎01-08-2018

@sn123,

You may select DirectQuery mode when connecting.

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.