While appending two or more tables- Taking too much time or failed

[Anonymous]

Dear Folks,

Could all of you please suggest , is there any other way to append the tables 2 or more as it is taking too much time or either failed to compiled.

Does it depend on net speed or local machine.

I am very dissapointed on this.

Power BI having too much drowbacks regarding compling,merging,refreshing on large amount of data but Tableau does in a seconds on any amout  of data ?

Sometimes feel PowerBI is on good ?

Whats your suggestions?

@amitchandak @parry2k @Anonymous @lbendlin @mahoneypat 

Thanks

Shiv

[parry2k]

@Anonymous my last reply to this post and sorry I cannot help further. Good luck!

[Anonymous]

Ok No issue. Thanks for your valuable reply

[parry2k]

@Anonymous just relax. Don't make an opinion until you hear the solution.

You can use parameters to filter records on desktop and the in Power BI service, you can change the parameter value to load the full table. There are tons of posts on how to do this.

[parry2k]

and it is called rant....you need to plan, there is no plan to do pull all the data while working on desktop, you can pull sample data and solution on it and then publish it to Power BI service, and pull the full data. Many ways to overcome, the question to ask, why someone need to pull the whole dataset in the desktop while developing the solution.  

Just my 2 cents.

[Anonymous]

I want to clear on data as I have developed the dashboard on sample data and before publishing on power BI service portal ,have to change the filter or not ? we all know have to change the filter.

if we published on portal and didnot change the filter in this case dashboard will refresh but it will not pick the data before date range or above date range.

Is option availabe to change date range or clear on power bi service portal ? ANSER IS NO

So how will we change

Only option is- change the date range or clear the filter from date range and pull the data then publish it on portal.

Dear parry it is not RANTING. You are ranting. please research on it or have any other option please request you to share logic here . Thanks ?

:):)

[parry2k]

@Anonymous your data source and latency/network speed

[parry2k]

@Anonymous very hard to comment on such little information. You can surely RANT, but without knowing the details, it is very hard to answer. Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Anonymous]

Dear Parry

I am not ranting, I am working on actual transactinal data .

One table having 30mn records and another having only 3mn and appending second table into 1st.

while appending it s showing only running nothing else.

My questions is 

does it depend on net speed or machine configuration or something other ?

is any other way to to this ?

Please chech below codes .

let
#"Appended Query" = Table.Combine({Source, #"db_CSA_Data Yield_Sec_Test1"}),
#"Changed Type" = Table.TransformColumnTypes(#"Appended Query",{{"InvoiceDate", type date}}),
#"Appended Query1" = Table.Combine({#"Changed Type", #"db_CSA_Data yield_master_PowerBI"})
in
#"Appended Query1"