Reducing the database CPU usage while refreshing data in PowerBI desktop

[Anonymous]

Hi All,

I am looking for some workarounds to reduce the CPU usage of database server. We are using oracle database and the normal data source is a query were we key in the query (pasted below) into advanced editor to establish connectivity with our RESTAPI views. We are looking for any possible query optimization or different possible approach for establishing easy loading and data refresh with optimal DB server usage. 

let
// Query for PowerBI Basic with username password
Source = try Csv.Document(Web.Contents(restBaseUrl & "/api/views/transmitted_doc_recipients?response_type=csv&selected_columns=project_code,staff_code_recipient,transmittal_code_recipient,responsible_engineer_ind",
[Timeout=#duration(0,0,30,0), ManualStatusHandling={400,401,403,404,405,406,429,500,502,503}]),
[Columns=82])
otherwise Table.PromoteHeaders(Table.FromRecords({[ERROR="Error"]}), [PromoteAllScalars = true]),
#"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true])
in
#"Promoted Headers"

Thanks

Vinu

[v-alq-msft · Accepted solution]

Hi, @Anonymous 

I'd like to suggest you try optimizing the data model which supports the entire visualization  experience. There are three dataset modes: Import, DirectQuery, and Composite. For specific dataset mode guidance, see:

• Data reduction techniques for Import modeling
• DirectQuery model guidance in Power BI Desktop
• Composite model guidance in Power BI Desktop

For further optimization in Power BI, please refer to the document .

Best Regards

Allan

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