PowerBI behaves buggy when copying queries to clipboard. I started investigating this, as I am the developer of https://powerqueryformatter.com where I integrated a feature that allows pasting queries with dependencies directly from powerBI into the editor (much like you can copy and paste queries with dependencies in powerbi). The feature works well in chrome but it does not work in Firefox where the content with mime-type "text/html" is always empty string.
I started investigating what is copied to the clipboard by powerbi using this tool https://www.nirsoft.net/utils/inside_clipboard.html . Under format "HTML Format" the content in the clipboard that is set by PowerBI looks like this
Format:HTML Format
Version: 1.0
StartHTML: 0
EndHTML: 0
StartFragment: 0
EndFragment: 0
<!DOCTYPE html>
<html>
<body><!--StartFragment--><div class="microsoft-mashup-format"><?xml version="1.0" encoding="utf-8"?><Mashup xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/DataMashup"><Client>PBIDesktop</Client><Version&... Name="FaktArbeitszeiten"><Formula><![CDATA[let
Quelle = Excel.Workbook(Web.Contents("https://mogulargmbh.sharepoint.com/sites/mogularOrga/Freigegebene%20Dokumente/Zeiterfassung%20Uli/Ze...;), null, true),
tblArbeitszeiten_Table = Quelle{[Item="tblArbeitszeiten",Kind="Table"]}[Data],
#"Andere entfernte Spalten" = Table.SelectColumns(tblArbeitszeiten_Table,{"Tag", "Arbeitszeit", "Abwesenheit", "Kommentar"}),
#"Geänderter Typ" = Table.TransformColumnTypes(#"Andere entfernte Spalten",{{"Tag", type date}, {"Arbeitszeit", type time}, {"Abwesenheit", type text}}),
#"Hinzugefügte benutzerdefinierte Spalte" = Table.AddColumn(#"Geänderter Typ", "Benutzerdefiniert", each (Time.Hour([Arbeitszeit]) * 60 + Time.Minute([Arbeitszeit])) / 60),
#"Umbenannte Spalten" = Table.RenameColumns(#"Hinzugefügte benutzerdefinierte Spalte",{{"Benutzerdefiniert", "Arbeitszeit in h"}}),
#"Entfernte Spalten" = Table.RemoveColumns(#"Umbenannte Spalten",{"Arbeitszeit"}),
#"Gefilterte Zeilen" = Table.SelectRows(#"Entfernte Spalten", each [Arbeitszeit in h] <> null and [Arbeitszeit in h] <> 0 or [Abwesenheit] <> null),
#"Geänderter Typ1" = Table.TransformColumnTypes(#"Gefilterte Zeilen",{{"Arbeitszeit in h", type number}}),
#"Gefilterte Zeilen1" = Table.SelectRows(#"Geänderter Typ1", each [Tag] >= #date(2019, 10, 1))
in
#"Gefilterte Zeilen1"]]></Formula><LoadToReport>true</LoadToReport><IsParameterQuery>false</IsParameterQuery><IsDirectQuery>false</IsDirectQuery></Query></Items></Mashup></div><!--EndFragment--></body>
</html>
Note that in the header StartHTML and EndHTML as well as StartFragment and EndFragment are all 0. If we refer to this clipboard api specification https://docs.microsoft.com/en-us/windows/win32/dataxchg/html-clipboard-format these properties must be filled with the corresponding values. Maybe chrome is able to determine these values without explicitely setting them in the header but apparently firefox isn't able to do that. As far as I'm concerned this bug resides in powerbi or maybe an underlying technology that you are using to write html to the clipboard.
It would be nice if this would get fixed. Otherwise I'm not able to provide this specific feature of my service to Firefox users.
Hongju_Jung
on:
Translation Issue in the Korean Version
on:
Issue with new card visual - reference labels spac...