topic Re: While appending two or more tables- Taking too much time or failed in DAX Commands and Tips

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

Anonymous — Sat, 30 Jan 2021 02:51:27 GMT

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

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

parry2k — Sat, 30 Jan 2021 03:06:50 GMT

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

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

Anonymous — Sat, 30 Jan 2021 03:40:47 GMT

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"

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

parry2k — Sat, 30 Jan 2021 03:42:19 GMT

Anonymous your data source and latency/network speed

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

parry2k — Sat, 30 Jan 2021 03:45:40 GMT

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.

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

Anonymous — Sat, 30 Jan 2021 03:57:14 GMT

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 ?

:):)

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

parry2k — Sat, 30 Jan 2021 04:05:28 GMT

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.

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

parry2k — Sat, 30 Jan 2021 04:06:26 GMT

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

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

Anonymous — Sat, 30 Jan 2021 04:10:48 GMT

Ok No issue. Thanks for your valuable reply