Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
When connecting to a data srouce in Power BI Desktop, data type will be changed in Power Query automatically based on your data. If this data type is not what you want, you could change the data type in Power Query and check if this issue persists or not.
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"
Regards,
Charlie Liao
When connecting to a data srouce in Power BI Desktop, data type will be changed in Power Query automatically based on your data. If this data type is not what you want, you could change the data type in Power Query and check if this issue persists or not.
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"
Regards,
Charlie Liao
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |