User Profile
erikjanpoelen
Frequent Visitor
Joined 7 years ago
User Widgets
Contributions
REST API using Windows authentication
Hello everbody, I would like to do a GET to a REST API to retrieve data in html or json. The REST API works with Windows Authentication. It does not ask for a username and password but simply checks your windows account. That would be the following in Power BI: The goal is that whenever an end-user is using this Power BI report through a workspace, they will only see the data (from this REST API) to which they have access to. Is that possible? Using the WEB URL connector I can retrieve the data, but I think that's a simply import, so it will only use my credentials and access permissions are not applied for each user. Please help!Return the minimum date when comparing two date columns (while ignoring blanks)
I want to retrieve the earliest date out of two date colums. However, the MIN function does not help me as it sees BLANKS as 0, thus choosing BLANKS over a date, while I am looking for the date when the other column is empty. Is there a work-around available? Excel seems to do this just fine.
