cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Allan77R2V1 Regular Visitor
Regular Visitor

User PowerBI to show all users in my O365 tenant that have a PowerBI pro license

I want to get a list of people in my Orgnazation using PowerBI pro.  I cant seem to figure out if there is a API for this. Has anyone successfully done this?

10 REPLIES 10
Highlighted
Moderator v-yuezhe-msft
Moderator

Re: User PowerBI to show all users in my O365 tenant that have a PowerBI pro license

@Allan77R2V1,

You can get number of users that are assigned with Power BI Pro licenses by connecting to Office 365 Adoption content pack. If you want to list user names, please use PowerShell as described in the blog below.

http://windowsitpro.com/office-365/office-365-licensing-windows-powershell

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Allan77R2V1 Regular Visitor
Regular Visitor

Re: User PowerBI to show all users in my O365 tenant that have a PowerBI pro license

Thank you! Do you know if the O365 Adoption content pack will eventually have the list of users for PowerBI? Seems strange to me that user list are avilable for all the other products but not PowerBI.

Moderator v-yuezhe-msft
Moderator

Re: User PowerBI to show all users in my O365 tenant that have a PowerBI pro license

@Allan77R2V1,

How do you create the user list for other products? I can see the number of users when using Power BI Desktop to connect to Office 365 Adoption PBIT file, you can check the user name for Power BI in the appropriate table by connecting to the PBIT file.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Allan77R2V1 Regular Visitor
Regular Visitor

Re: User PowerBI to show all users in my O365 tenant that have a PowerBI pro license

This brings up another issue that I have not been able to resolve. Whenever I try to use the pbit file I enter my tenant inf but fail to pull the data with this error.  In my investigation there are lots of poeple with this issue but I cant find a fix.  However if I use PowerBI Web then the data loads fine.

 

DataSource.Error: OData: A supported MIME type could not be found that matches the content type of the response. None of the supported type(s) 'application/json;odata.metadata=minimal;odata.streaming=true;IEEE754Compatible=false, application/json;odata.metadata=minimal;odata.streaming=true;IEEE754Compatible=true, application/json;odata.metadata=minimal;odata.streaming=true, application/json;odata.metadata=minimal;odata.streaming=false;IEEE754Compatible=false, application/json;odata.metadata=minimal;odata.streaming=false;IEEE754Compatible=true, application/json;odata.metadata=minimal;odata.streaming=false, application/json;odata.metadata=minimal;IEEE754Compatible=false, application/json;odata.metadata=minimal;IEEE754Compatible=true, application/json;odata.metadata=minimal, application/json;odata.metadata=full;odata.streaming=true;IEEE754Compatible=false, application/json;odata.metadata=full;odata.streaming=true;IEEE754Compatible=true, application/json;odata.metadata=full;odata.streaming=true, application/json;odata.metadata=full;odata.streaming=false;IEEE754Compatible=false, application/json;odata.metadata=full;odata.streaming=false;IEEE754Compatib...' matches the content type 'text/html; charset=utf-8'.
Details:
    DataSourceKind=OData
    DataSourcePath=https://reports.office.com/pbi/v1.0/I removed the tenant address/TenantClientUsage

Moderator v-yuezhe-msft
Moderator

Re: User PowerBI to show all users in my O365 tenant that have a PowerBI pro license

@Allan77R2V1,

I am not able to reproduce your  issue, do you use September release of Power BI Desktop? Do you use Organizational account to sign in?

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Allan77R2V1 Regular Visitor
Regular Visitor

Re: User PowerBI to show all users in my O365 tenant that have a PowerBI pro license

Yes, I am runnin g the Sept release and Im using a Global Admin Org account. I have tried clearing the cached persmisions but no luck.

 

Anyone have any suggestions?

 

Moderator v-yuezhe-msft
Moderator

Re: User PowerBI to show all users in my O365 tenant that have a PowerBI pro license

@Allan77R2V1,

I would recommend you send a Frown in Power BI Desktop.

Regards,

Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
RobMahon Frequent Visitor
Frequent Visitor

Re: User PowerBI to show all users in my O365 tenant that have a PowerBI pro license

Did the latest version resolve your issue?  I'm on the latest version but have a similar issue.

Allan77R2V1 Regular Visitor
Regular Visitor

Re: User PowerBI to show all users in my O365 tenant that have a PowerBI pro license

No it hasnt solved my issue. I believe it is a API issue rather then a PowerBI issue. I had one of our Windows Admins create a powershell script that pulls the data and it works great. So the date is there, Microsoft just hasnt exposed it through reporting or APIs.

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,931)