bloigge
Advocate IV
11 years agoStatus:
Needs Votes
Make functions refreshable when the data source is a parameter of the function
Like discussed here: http://community.powerbi.com/t5/Integrations-with-Files-and/Refreshing-queries-with-functions-doens-t-work/td-p/2450 - queries where data access happens inside a function and whe...
jeremy_houghton
6 years agoNew Member
'@sdjensen: Refreshing of a dataset that contains functions in the power query still doesn't work for me. Everything runs fine using Power BI Desktop but as soon as I publish to the Power BI Portal and try to refresh the data from there I get an error. Below is an example of the power query that I am trying to run. Please excuse the lack of indentation as it seems to get removed after posting the comment. /* Gets the transaction file data as a table by url */ let getTransByFileUrl = (sourceTransFileUrl as text) => let sourceTransWeb = Web.Contents(sourceTransFileUrl) in let sourceTrans = try Csv.Document(sourceTransWeb, null, ",", null, 1252) in if sourceTrans[HasError] then #table(type table [],{}) else let sourceTransWithHeaders = Table.PromoteHeaders(sourceTrans[Value]) in Table.TransformColumnTypes( sourceTransWithHeaders, { {"Account", type text}, {"Account Number", type text}, {"Transaction Date", type date}, {"Transaction Amount", type number}, {"Transaction Description", type text}, {"Transaction Code", type text} } ) in /* Combines all the transaction file data for all source transaction files as a table */ let getTransByTransFiles = (sourceTransFiles as list) => Table.Combine( List.Transform( sourceTransFiles, (sourceTransFile) => getTransByFileUrl(sourceTransFile) ) ) in /* Generates a list of daily transaction file names starting from the specified start date with the specified folder and file name */ let getSourceTransFiles = (startDate, sourceTransFolderUrl, fileNameWithExt) => let dates = List.Dates(startDate, Number.From(DateTime.LocalNow () ) - Number.From(startDate), #duration(1, 0, 0, 0)) in List.Transform( dates, (date) => let fileUrl = sourceTransFolderUrl & Date.ToText(
Recent ideas
Paginated report - Subscription every 2nd Week option
Currently I have a lot of reports that would ideally run every 2nd week (payroll in New Zealand generally works on a fortnightly/2-weekly cycle). However the closest I can get is to either run sched...PeteCresswell3 hours agoNew MemberNew7Views0likes0CommentsIncrease or Make Configurable the Power BI Browser Tab Limit (Currently 20 Items)
Power BI users frequently work across multiple reports, dashboards, semantic models, notebooks, and Fabric artifacts simultaneously. The current browser limitation of 20 open Power BI/Fabric items re...sharadmahajan7 hours agoRegular VisitorNew238Views16likes1CommentEnable Fine-Grained, Least-Privilege Control Over Fabric Artifact Creation
Please introduce more granular permission controls that allow admins to determine which user groups can create specific Fabric artifacts. The current all-or-nothing model—where users can either creat...krish00712 hours agoNew MemberNew160Views2likes1CommentMS Fabric User Permission Segmentation by Artifacts
Currently, when we grant users permission to create Fabric artifacts, they can create anything available in the workspaces they have access to. This unrestricted access can lead to an unstructured en...Anonymous12 hours agoNot applicableNew329Views8likes2Comments