Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Incorrect Data being pulled from Excel Spreadsheet in SharePoint

I have an Excel Speadsheet located on Sharepoint which feeds into a Power BI Query. There are two columns containing dates, and a third column which holds a formula calculating the percentage of time...
  • Anonymous's avatar
    Anonymous
    8 years ago

    Anonymous,

    Do you firstly connect to the Excel located on SharePoint Online in a new Excel file using Power Query option and then create custom column to calcultate the percentage in Power Query?


    After that you import the Excel file that contains the custom column  to Power BI?  If so, I can't reproduce your issue. Could you please share your formula? Also why not directly connect to the Excel located in Sharepoint in Power BI Desktop and then create the percentage column?

    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Anonymous,

Do you firstly connect to the Excel located on SharePoint Online in a new Excel file using Power Query option and then create custom column to calcultate the percentage in Power Query?


After that you import the Excel file that contains the custom column  to Power BI?  If so, I can't reproduce your issue. Could you please share your formula? Also why not directly connect to the Excel located in Sharepoint in Power BI Desktop and then create the percentage column?

Regards,
Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Lydia,

 

I still can't figure out why there's a discrepency between the column values in the Excel on Sharepoint and the column values in Power BI. However, to get around the issue, I've created a calculated column in Power BI using the formula from Excel (modified for Power BI syntax). Thanks for your help!