cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

username() return NULL on publish service

Hi everyone:

 

I have a problem showing user in power bi publish service. 

I create an measures with DAX sencence:

 

UsuarioP = USERNAME()

 

usuarioFilter = LEFT(USERNAME();SEARCH("@";USERNAME())-1)

 

That measures in web desktop shows data OK:

 

UsuarioP show "user@....."

usuarioFilter show "user"

 

But after publish to the web, both shows NULL values.

 

Thank you!

6 REPLIES 6
Highlighted
Resolver IV
Resolver IV

Re: username() return NULL on publish service

@asola hello, it happens when you publish it and use the Public Link, is the case?

 

when you use the Link inside the service with an user, aways will appear for you.

 

Highlighted
Frequent Visitor

Re: username() return NULL on publish service

Hi:

 

Yes @henriquesilveir, when i use web editor, it`s ok. But when i use public link, becomes blank.

 

Thank you.

Highlighted
Resolver IV
Resolver IV

Re: username() return NULL on publish service

You cannot do nothing.. Always in public link will apper (null).

And in tje service will show the user.
Highlighted
Frequent Visitor

Re: username() return NULL on publish service

Hi:

 

Ok, thank you.

 

I use that for filter (like a slicer) dashboards. How can i filter in public link?

 

Than you.

Highlighted
Resolver IV
Resolver IV

Re: username() return NULL on publish service

Hi @asola You can duplicate some of your reports and apply a report filter. 

 

Highlighted
Frequent Visitor

Re: username() return NULL on publish service

Hi:

 

Thank you @henriquesilveir

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Kudoed Authors