Forum Discussion

karthiks1983's avatar
karthiks1983
Regular Visitor
9 years ago
Solved

Data load from Share point - column with formula applied

I am trying to load data from one of the share point with both columns populated manually/calculated to PowerBI. The connection was successful. But few columns in share point that has value populated...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi karthiks1983,

     

    Based on my test in Power BI desktop version 2.42.4611.901, I'm able to get calculated column in a SharePoint online list.

     

    I created the calculated column in the SharePoint online list like below:

     

     

    When I get data in Power BI desktop use SharePoint online list data source, calculated column will display correct values instead of 0. See:

     

     

    In your scenario, please check which desktop version did you run. If possible, please share more detail steps for us to reproduce the issue.

     

    Best Regards,
    Qiuyun Yu

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
9 years ago

Hi karthiks1983,

 

Based on my test in Power BI desktop version 2.42.4611.901, I'm able to get calculated column in a SharePoint online list.

 

I created the calculated column in the SharePoint online list like below:

 

 

When I get data in Power BI desktop use SharePoint online list data source, calculated column will display correct values instead of 0. See:

 

 

In your scenario, please check which desktop version did you run. If possible, please share more detail steps for us to reproduce the issue.

 

Best Regards,
Qiuyun Yu