PowerBi Report for SkypeForBusiness Online

[SurendraP]

Guys, I need help creating powerBi reports for Skype for Business online(Azure), we have migrated to SFB recently, they have some prebuilt reports on portal but we want to create more descriptive reports in powerbi for PSTN and other skype report havign data like 'Inbound # \ Outbound # \ Call Time \ Call Answered (Yes\No) \ Abandon call etc' but unable to get this data. Tried using APIs 

(https://developer.microsoft.com/en-us/graph/docs/api-reference/beta/api/reportroot_sfbactivity) but not getting exact data and for PSTN report not able to get any APIs.

If anyone created reports/ havign information on SFB Online then please share, will be greatly appreciated. 

Thank you in advanced. 

[SurendraP]

Hi, Anyone got any information or idea buiding PowerBi Report for Skype for Business which is in cloud. please share... 

[v-sihou-msft]

@SurendraP

Based on your attached link, it seems the API return "stream" type. I don't it can be used for retrieving data in Power BI Desktop. In my opinion, you'd better get the data from the database for Lync. However, you are using Skype for Business online, I don't think it's allowed to get the data from the backend database hosted on cloud side. 

Regards,

[SurendraP]

@v-sihou-msft 

We can not get data directly from cloud therefore trying to build reports based on SFB Reports in Azure portal via APIs, you are right we can not point Stream API to desktop but I am looking to insert into Push dataset in powerbi Web by live streaming channels.