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.
Hi I Imported a table in power query from excel. In Power Query I have also other table from our DWH.
It's everything ok until I publish the Power BI analysis because my gateway ask me where is the excel file imported (He doesn't find the path)....If i see the table in power query I see that:
let
Origine = Excel.Workbook(File.Contents("C:\Users\padovani.c\Desktop\Categorie catastali.xlsx"), null, true),
CategoriaCatastale_Sheet = Origine{[Item="CategoriaCatastale",Kind="Sheet"]}[Data],
#"Modificato tipo" = Table.TransformColumnTypes(CategoriaCatastale_Sheet,{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}, {"Column4", type text}}),
#"Intestazioni alzate di livello" = Table.PromoteHeaders(#"Modificato tipo", [PromoteAllScalars=true]),
#"Modificato tipo1" = Table.TransformColumnTypes(#"Intestazioni alzate di livello",{{"Categoria catastale", type text}, {"Tipologia_Catasto", type text}, {"Tipologia_CF", type text}, {"Destinazione_CF", type text}})
in
#"Modificato tipo1"
In the Origin there is the Path that the Power BI gateway wants....how do i delete the reference to the path, since the table no longer needs to update (it is a static table)?
thank you
Solved! Go to Solution.
It may work to right click on the query and uncheck "Include in Report Refresh". A better fix would be to put your file on SharePoint or OneDrive and connect to it there, so a Gateway is not necessary.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
It may work to right click on the query and uncheck "Include in Report Refresh". A better fix would be to put your file on SharePoint or OneDrive and connect to it there, so a Gateway is not necessary.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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 |
---|---|
102 | |
53 | |
21 | |
12 | |
12 |