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
Display the Business Names in Power BI report when using ODBC connection to connect to Datasphere.
Currently we are only able to see the technical names displayed in Power BI when the Datasphere report is exposed to Power BI using the ODBC connection. It would be better if we have the option to di...VinayLohakare33 minutes agoNew MemberNew3Views0likes0CommentsDo not deploy flag to alert users in Deployement pipeline
Hello. I have some notebooks that have differences between workspaces that I'm aware of, where it's by design. For example, I have a notebook creating a table in the attached lakehouse with unique i...GregoryDF1 hour agoFrequent VisitorNew177Views1like1CommentPower BI Admin to Disable the New Ribbon Preview & Control Rep Toolbar Visibility at Tenant Level
Allow Power BI Administrators to Disable the New Ribbon Preview and Control Report Toolbar Visibility at Tenant Level It takes too much real estate and by default users with low maturity leaves it a...icassiem3 hours agoPost ProdigyNew112Views11likes3CommentsManage and Control Personel Bookmarks in Power BI Service
It should be possible for admin to monitor and manage the personal bookmark created by end users.ozanbaris_bayra4 hours agoRegular VisitorUnder Review1.9KViews36likes10CommentsComprehensive Requirements and Enhancements for Sankey Chart Visuals
Hey Team, I have reviewed and compiled all the feedback, discussions, and ideas shared regarding the Sankey chart visual enhancements into this document. If there are any suggestions I may have mis...alvinquwwata2906 hours agoNew MemberNew291Views4likes2Comments