Publishing failed for an unknown reason. (Failed to refresh package after import error)

[jeff44]

NULL

[fbcideas_migusr]

I have functions - I replaced my queries calling my functions with reading straight from an Excel file. The functions are still in my pbix file but not referenced. Now it will publish. The original version still wont publish. So I think this issue is triggered by calling a function.

[BInsure1]

I have the same problem : publishing failed for unknown reason any idea anyone ??

[irsimeonov]

Same here - I cannot publish a pbix or excel file to power bi regardless of whether I try to do it via power bi desktop or directly import from power bi online.

[slivkam]

I had data load working and it contains one function and folder query as bellow: Folder query: let Source = Folder.Files("C:\Users"), #"Removed Other Columns" = Table.SelectColumns(Source,{"Name", "Folder Path"}), #"Added Custom" = Table.AddColumn(#"Removed Other Columns", "Path", each [Folder Path] & [Name]), #"Added Custom1" = Table.AddColumn(#"Added Custom", "XML Data", each getData_UsersJSON([Path])), #"Removed Columns" = Table.RemoveColumns(#"Added Custom1",{"Name", "Folder Path", "Path"}), #"Expanded XML Data" = Table.ExpandRecordColumn(#"Removed Columns", "XML Data", {".AExportableUser"}, {"XML Data..AExportableUser"}), #"Expanded XML Data..AExportableUser" = Table.ExpandRecordColumn(#"Expanded XML Data", "XML Data..AExportableUser", {"created", "email", "exportablePassword", "exportablePasswordSalt", "firstname", "hidden", "id", "lastname", "locked", "memberOf", "name", "tenantId", "updated"}, {"XML Data..AExportableUser.created", "XML Data..AExportableUser.email", "XML Data..AExportableUser.exportablePassword", "XML Data..AExportableUser.exportablePasswordSalt", "XML Data..AExportableUser.firstname", "XML Data..AExportableUser.hidden", "XML Data..AExportableUser.id", "XML Data..AExportableUser.lastname", "XML Data..AExportableUser.locked", "XML Data..AExportableUser.memberOf", "XML Data..AExportableUser.name", "XML Data..AExportableUser.tenantId", "XML Data..AExportableUser.updated"}), #"Filtered Rows" = Table.SelectRows(#"Expanded XML Data..AExportableUser", each [#"XML Data..AExportableUser.id"] <> null and [#"XML Data..AExportableUser.id"] <> "") in #"Filtered Rows" Function:(path as text) => let Source = Json.Document(File.Contents(path)) in Source If I remove my folder query I am able to publish my dashboard. It was working until Friday morning and then it stopped. I need to use this functionality as I am getting weekly reports that I need to load from the folder.

[slivkam]

same issue since yesterday 21 Oct 2016

[slivkam]

I think the problem is the function not the folder query. if I do not use function I can publish...

[slivkam]

yes calling the function causes the problem!!!

[Søren]

My import to PowerBI also fails, getting error codes 500 and 200. I noticed that the import fails when I add a query that uses a parameter to insert path for my source files dynamically. As soon as I delete the query using parameters the pbix file uploads without error.

[daniilmaslyuk_p]

Can't publish a .pbix regardless of whether there is folder path query or not -- even super simple .pbix won't publish.

[bruno23]

I have the same problem... Any update? Please!