Tony Valentine

My feedback

  1. 133 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Tony Valentine commented  · 

    Please, please, please do this. We are racking lots of VM costs just to run the gateway! Although I suppose it's good for the Azure business :P

    Tony Valentine supported this idea  · 
  2. 14 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Power BI Ideas » APIs and Embedding  ·  Flag idea as inappropriate…  ·  Admin →
    Tony Valentine shared this idea  · 
  3. 53 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Tony Valentine commented  · 

    In addition to my original request, I'd like to request a related feature. Why not also allow a PBIX file to be sourced from a gateway the same way Power BI for the web does? This would make it easier for users to find data sources and avoid issues with connection string sprawl and FQDN/non-FQDN name mismatches. You could then say that if the PBIX file is sourced from the gateway, that then when the user uses "Analyze in Excel", that it also routes through the gateway as is desired in my original request.

    Tony Valentine shared this idea  · 
  4. 56 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Tony Valentine commented  · 

    I would love to see it at both the gateway and data source level, with the data source level overriding anything at the gateway level. This way if for some reason you did need different mappings per data source, then you could still do it.

    Tony Valentine supported this idea  · 
  5. 109 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    25 comments  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
    Tony Valentine commented  · 

    Well msmdpump.dll is not supported but it appears Power BI has added the capability to map usernames. If you go to the Data Source Settings and toggle to the Users tab, there is a button called Map User Names which lets you alter the EffectiveUsername string via custom mappings. Thank you MSFT for adding this feature!!

    Tony Valentine supported this idea  · 
    Tony Valentine commented  · 

    This still does not work with the release version of Power BI Analysis Services Connector. It fails with the same 404 error. Any update on where this feature is on the priority list?

    Tony Valentine commented  · 

    Thanks for the response. I would think it is minimal work to make msmdpump.dll work, but I can't say since it's not my code. As far as I know, all other Microsoft products that work with SSAS connections support msmdpump.dll, so for consistency alone I think it would good.

    Translating identities would be nice because it provides any provider who is hosting an SSAS based solution for a client to provide data via Power BI without having a robust and expensive web API that the big guys have (SendGrid, Zendesk, etc).

    Tony Valentine commented  · 

    Yes, I can access the AS server using the HTTP pump in Excel and SSMS. It's bit complicated, but the reason I want the pump is I want to allow users on external domains to access our data warehouse. We provide our clients a hosted BI solution. I can easily write a proxy web application for the pump that will take the EffectiveUsername from their domain (client\username) and convert it to our domain via a lookup in LDAP (we can store their local AD name in a AD field in our domain). I have done a similar proxy in the past to add certificate based authentication for the pump. However, if the Power BI will not allow me to use the pump, then I have no way hijack via a proxy to convert the EffectiveUsername to our domain. Here is a link to someone who did something similar to my proxy... https://code.msdn.microsoft.com/SSASProxy-Custom-HTTP-7db6d016#content

    Tony Valentine shared this idea  · 

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.