I am attempting migrate some of my PBI Desktop queries to Dataflows in the BI Service.
Some of these queries reference a function, The function accepts an argument of a URL - this URL is then used to extract all the items in a particular list on that project site. However when the function is referenced in the query it is asking for credentials. When I attempt to enter credentials via an organisational account the option to sign is is greyed out even though the dialog suggests I am not signed in. Any ideas?
LoadList = (site as text) =>
Source = OData.Feed(site&"/_api/lists/getbytitle('Risks')/items")
Thank you for the tip but I can confirm that there are no pop-ups being blocked. I can connect to the same data source in another connection but it appears that Dataflow features cannot currently cope with this type of function. The step on which the error occurs is when attempting to connect to a SharePoint API to return items from a list but there is no source to assign credentials in the function - however this works in Power BI Desktop.