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
Option to set custom width for gridlines OR fixed outer padding
When designing reports, using the align and distribute evenly options in the format pane are useful, however when designing report pages with fixed bleeds between visuals I have to follow these steps...IolaWhiteley3 hours agoAdvocate IINew2Views0likes0CommentsDefault Scrollable Time-Series Charts to Most Recent Data
Currently, Power BI time-series charts always open scrolled to the earliest (leftmost) date by default, which is inconvenient for reports where users are interested in the most recent (rightmost) dat...CStillwell4 hours agoNew MemberNew21Views2likes1CommentOption to Stop Fabric Planning Billing Session After Plan Item Deletion
Currently, a Fabric Planning session remains active for 30 days once triggered. If a user creates a Plan item only for testing and deletes it the next day, the billing session still continues and c...v-dugumarrir16 hours agoMicrosoft EmployeeNew44Views10likes1Comment