embedded upload AND publish to app.powerbi FAILED for an unknown reason

[ThomasDay]

Hello all,

After months of really great uploading to both app.powerbi and to an embedding workspace, three of our models would not upload to powerbi or upload to the azure workspace.  We've made a bunch of data and bug fixes.  All works well here on desktop without any notices.

I've submitted a ticket, and after three hours with tech support--we're no further along.  (He's now looking at a trace file and fiddler output.)  

Seemed like it started exactly after the powerpoint export preview notice on Thursday.....

Has anyone had this issue or have any clues what's going on?   Tom

[ThomasDay]

Here's more information.

All of the models have successfully uploaded to our Azure embedded workspace and our app.powerbi service many dozens of times.

All of the models that failed to upload to our Azure embedded workspace on Friday also failed to upload to app.powerbi with exactly the same error messages shown above.

All of the models that continue to upload to our Azure embedded workspace also continue to upload to app.powerbi.

AND all the models that failed used GetData and Combine in their queries like the example below...and all the ones that uploaded did not.

let
    GetData = (path) => let
    Source = Csv.Document(File.Contents(path),[Delimiter=",", Columns=4, Encoding=1252, QuoteStyle=QuoteStyle.None]),
    #"Promoted Headers" = Table.PromoteHeaders(Source),
    #"Renamed Columns" = Table.RenameColumns(#"Promoted Headers",{{"Row Labels", "ReptRecNo"}}),
    #"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"ReptRecNo", Int64.Type}, {"Variable_Value", type number}}),
    #"Removed Blank Rows" = Table.SelectRows(#"Changed Type", each not List.IsEmpty(List.RemoveMatchingItems(Record.FieldValues(_), {"", null})))
in
    #"Removed Blank Rows",
	CY= GetData("C:\Users\trday\Dropbox\FTRatings\FTRatingsData-Models\Stage2-DataLoad\MeasuresData-Current.csv"),
	PY= GetData("C:\Users\trday\Dropbox\FTRatings\FTRatingsData-Models\Stage2-DataLoad\MeasuresData-Prior-1.csv"),
	Combine = Table.Combine({CY, PY})
in
	Combine

[ThomasDay · Accepted solution]

Support tells me that this is a known bug and the fix will be up on Friday

[v-micsh-msft]

Hi ThomasDay,

Thanks for sharing this.

Regards