- In Power BI Desktop, create parameters for the file path and name as well as the local time zone offset to UTC.
File path and time zone parameters in the Query Editor
- Create a blank query that returns the full file path based on the parameters per the image of PBIAuditLog.
- Create a new query to the CSV file on the network and replace the file path with the query, based on the parameters:
let Source = Csv.Document(File.Contents(PBIAuditLog),[Delimiter=",", Columns=5, Encoding=65001, QuoteStyle=QuoteStyle.Csv]), RemoveTopRows = Table.Skip(Source,2), PromoteHeaders = Table.PromoteHeaders(RemoveTopRows, [PromoteAllScalars=true]), ...
Get Microsoft Power BI Cookbook now with O’Reilly online learning.
O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.