0

I have a power bi report with four connections to four excel files.

One of the files is around 1500 rows and 800 KB of memory.

The query i am interested in appends three queries, each one of those queries is merged with the 1500 rows file. (query dependencies here)

When i refresh the report, it takes a long time before the query loads up to 800 MB from that file (Big refresh here).

Is it due to amount of relations between tables, bad architecture or is it a bug?

Improve this question
Related questions
0
From excel to Power BI to Power Query: how can I make it easier for a user to update a query
0
Excel Power Query remove merged columns from Excel source before loading
0
Keeping existing data in data model and just extend it with new data
Load 4 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.