Forum Discussion

sham_powerBI's avatar
sham_powerBI
Frequent Visitor
10 years ago

SharePoint Online List- Power BI - slow query update

I am trying to create a dashboard using Power BI desktop app. My data source is a SharePoint Online list. I updated the data setto clean it up. the issue that when I tried to apply changes to the que...
Need Help
gpiero's avatar
gpiero
Icon for Skilled Sharer rankSkilled Sharer
9 years ago

trebgatte

 

Many thanks

 

It works in a woderful way

 

I have updated Query #1 ( just for test) in 25 seconds

let
    Source = OData.Feed("https://mysite.sharepoint.com/sites/Wmsh/it/Shpmt/SH_OutMgt/_api/web/lists/GetByTitle('Lista consegne per periodo')/Items()"),
    #"Renamed Columns" = Table.RenameColumns(Source,{{"ID", "ID.1"}})
in
    #"Renamed Columns"

 

Thanks again

gpiero's avatar
gpiero
Icon for Skilled Sharer rankSkilled Sharer
9 years ago

Just an update:

the query instructions after the example above make the difference.

 

I copied my report using the same query but the first one links using OData.Feed and I left the other as it was at the begining.

 

Both take basically the same time to refresh data.

 

Are there CBA to improve the query execution?