Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I have a file from azure datalake that is uploaded in PBI.
PBI automatically creates various scripts, li,ke:
let
Source = DataLake.Contents("adl://tenant.azuredatalakestore.net/Folder/File.csv"),
Navigation1 = Source{0}[Content],
in
Navigation1
However, when refreshing in PBI desktop, the script is transferred to:
let
Source = DataLake.Contents("adl://tenant.azuredatalakestore.net/Folder/File.csv"),
Navigation1 = Source{0}[Content],
#"Imported CSV" = Csv.Document(Navigation1,[Delimiter=":", Columns=19, Encoding=1252, QuoteStyle=QuoteStyle.None]),
#"Changed Type" = Table.TransformColumnTypes(#"Imported CSV",{{"Column1", type text}, {"Column2", Int64.Type})
in
#"Changed Type"
And this is wrong, it should not change.
How to avoid this?
Thanks,
Johan
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 36 | |
| 33 | |
| 31 | |
| 28 |
| User | Count |
|---|---|
| 129 | |
| 88 | |
| 79 | |
| 68 | |
| 63 |