Forum Discussion

admin11's avatar
admin11
Icon for Memorable Member rankMemorable Member
5 years ago

How to display CSV raw data update at PBI report ?

Hi All I have a SALES table , this sales table raw data file in CSV format ,  is store at sharepoint , this raw data file will auto update at sharepoint every day 3 Am. Am i able to display the CSV...
Need Help
V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi admin11 ,

 

 

  • Click 'Get data' from the ribbon
  • Select to get data From Folder/SharePoint Folder
  • Select your Folder/SharePoint Folder which has your target file(s)
  • Click 'Transform' button
  • Use the column filter for the 'Name' column which will have the filename for your desired file(s)
  • Remove all other columns except Date modified

 

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • admin11's avatar
    admin11
    Icon for Memorable Member rankMemorable Member
    5 years ago

    Hi V

    Thank you for sharing.

    I have no issue to import the CSV file to PBI. only issue is i have problem to display thhe raw data date field at PBI screen.

    Paul