Refresh error when combining multiple Web queries

[chocy]

Hi, below is the error i get when i try to refresh my data in power bi service. futher down is an example (not actual sources) of the multi source query drawing in the data. the data refreshes fine in PowerBi desktop. not sure why its not working in powebi service??

let
Source1 = Csv.Document(Web.Contents("https://www.sharepoint.com/file1.csv"),[Delimiter=","]),
#"Promoted Headers1" = Table.PromoteHeaders(Source1, [PromoteAllScalars=true]),
#"Changed Type1" = Table.TransformColumnTypes(#"Promoted Headers8",{{"ACCOUNTING YEAR", type text}, {"PERIOD", type text}, {"ACCOUNT", type text}, {"NET", type number}}),

Source2 = Csv.Document(Web.Contents("https://www.sharepoint.com/file2.csv"),[Delimiter=","]),
#"Promoted Headers2" = Table.PromoteHeaders(Source2, [PromoteAllScalars=true]),
#"Changed Type2" = Table.TransformColumnTypes(#"Promoted Headers8",{{"ACCOUNTING YEAR", type text}, {"PERIOD", type text}, {"ACCOUNT", type text}, {"NET", type number}}),

Source3 = Csv.Document(Web.Contents("https://www.sharepoint.com/file3.csv"),[Delimiter=","]),
#"Promoted Headers3" = Table.PromoteHeaders(Source3, [PromoteAllScalars=true]),
#"Changed Type3" = Table.TransformColumnTypes(#"Promoted Headers8",{{"ACCOUNTING YEAR", type text}, {"PERIOD", type text}, {"ACCOUNT", type text}, {"NET", type number}}),

Source4 = Csv.Document(Web.Contents("https://www.sharepoint.com/file4.csv"),[Delimiter=","]),
#"Promoted Headers4" = Table.PromoteHeaders(Source4, [PromoteAllScalars=true]),
#"Changed Type4" = Table.TransformColumnTypes(#"Promoted Headers8",{{"ACCOUNTING YEAR", type text}, {"PERIOD", type text}, {"ACCOUNT", type text}, {"NET", type number}}),

#"TableCombined" = Table.Combine({#"Changed Type1", #"Changed Type2", #"Changed Type3",#"Changed Type4"})
in
#"TableCombined"

[v-yulgu-msft]

Hi @chocy,

Here is a similar thread, please check if it helpful to your scenario:

[Unable to combine data] accessing data sources that have privacy levels

Regards,

Yuliana Gu

[chocy]

This doesnt work and i still get the same error, current file size is 800MB. When i separate my multisource query (another answer proposed on another thread) into individul queries this blows the file size out to 1.3GB at which point i then am no longer able to publish due to 1GB upload limit. I dont understand how POWERBI desktop can read my multi source query fine and refresh fine, but the POWERBI service just S#!ts itself????