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
Native SAP SuccessFactors and Active Directory Connectivity for Simplified Data Integration
Having native connectors for SAP SuccessFactors and Active Directory would eliminate the need for workarounds such as notebooks, custom scripts, or complex integration setups. Users should be able...João_Cristo1 hour agoNew MemberNew3Views0likes0CommentsAllow Azure Databricks streaming tables to be mirrored into Fabric
Mirroring an Azure Databricks Unity Catalog into Fabric silently drops streaming tables. They are not greyed out, not flagged, not explained. They simply do not appear in the picker, so there is no w..._taab3 hours agoNew MemberNew5Views0likes0CommentsPower BI, import report and semantic model: show change connection pop-up
When you need to import an existing Power BI report and semantic model in Tenant B that's created in Tenant A, you need to jump through a number of hoops to fix the original connection. It's doable, ...Reitse4 hours agoMost Valuable ProfessionalNew11Views1like0CommentsEnable per-user security for shared gateway connections using service accounts
When a shared gateway connection uses a highly privileged service account, all source queries run with that account’s permissions. Users cannot see the stored credentials, but report developers who c...AshishChougala4 hours agoMicrosoft EmployeeNew14Views6likes0Comments