Forum Discussion
PowerBI Desktop Refresh Times out
Hi Users, I have millions of rows in sql database and connected with powerbi desktop. All went well but recently i got an error as always times out. Lets see an example. I have an 3 years of Fiscal...
The Master is an append of all the FY-tables meaning that when that query is running it's triggering all the individual underlying queries, even if they are assigned to not load. I'm going to be honest, I'm not sure if this works but you should start out by toggling off "Include in report refresh" for each FY table.
If this doesnt work i belive you will need to append FY 18-20 seperatly and assign it to not be refreshed while keeping the FY 21 table entirely seperate.
/ J
Thanks for replying.
It wont work also I cant remove the refresh in the master table because it should be refreshed on every months new data.