POWER BI in SharePoint

[Syndicate_Admin]

Hi,

I have created a list in SharePoint and I am creating POWER BI report using the option provided in SharePoint.

I have created calculated column which is number and for some reason POWER BI is not reading it as number column.

Well I need SUM of the pending hours . How to do it in Power BI SharePoint. I cant go for Power BI desktop option since I need it in SharePoint platform.

Appreciate any help

Regards

[Syndicate_Admin]

@Expiscornovus 

Thanks a lot 

Yes looks like there is no option at the moment . So I need check to on POWER BI desktop any bring those reports to SharePoint site 

Regards

[Syndicate_Admin]

Hi @amitkabadi,

As far as I am aware Power Query is not available in that integration app. So, you can't use that Power Query code snippet I shared earlier in that approach.

I was suggesting to use Power Query to transform that calculated field from the source data via a dataflow:

https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-create#create-a-datafl...

However, the usage of that feature does require some specific licensing

Dataflows can be created by user in a Premium workspace, users with a Pro license, and users with a Premium Per User (PPU) license.

[Syndicate_Admin]

Hi @amitkabadi,

Are you using Power Query to interact with the SharePoint List?

https://docs.microsoft.com/en-us/power-query/connectors/sharepointonlinelist

If so, can you try and transform it with the following Power Query code:

let
  Source = SharePoint.Tables("https://contoso.sharepoint.com/sites/sourcesite", [ApiVersion = 15]),
  Navigation = Source{[Id = "a36ede88-5c99-47ee-96fe-c3c6e347d54a"]}[Items],
  #"Changed column type" = Table.TransformColumnTypes(Navigation, {{"Pending Hours", Int64.Type}}),
  #"Calculated sum" = List.Sum(#"Changed column type"[Pending Hours])
in
  #"Calculated sum"

[Syndicate_Admin]

@Expiscornovus 

I am new to POWER BI app

Actually I am using the SharePoint & Power BI  Integration app as shown below

Unfortunately here we don't have option to Transform data like we have in POWER BI desktop app

Regards