POWER BI in SharePoint

(0) Share

Report

Posted on by amitkabadi

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

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Expiscornovus 33,867 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
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"

Was this reply helpful? Yes No
amitkabadi 43 on at

Like (0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
Expiscornovus 33,867 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @amitkabadi,

As far as I am aware Power Query is not available in that integration app, https://powerbi.microsoft.com/en-us/blog/quickly-create-reports-from-sharepoint-lists/. 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-dataflow-using-define-new-tables

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.

Was this reply helpful? Yes No
amitkabadi 43 on at

Like (0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No