Forum Discussion

Jan_Kalina's avatar
Jan_Kalina
New Member
7 years ago
Solved

General Ask

Hi, I have this situation... I have a Excel file, which I edit in real time on my laptop, weanwhile I want to show some of my data of it for public on second screen as are this data changing. I wou...
Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    Hi Jan_Kalina,

    Based on my research, you could upload your excel file on OneDrive or SharePoint Online,when you connect to your file on OneDrive or SharePoint Online, a dataset is created in Power BI. Data from the file is then imported into the dataset in Power BI. Power BI then automatically connects to the file and refreshes any changes with the dataset in Power BI. 

    You could refer to below reference:

    https://docs.microsoft.com/en-us/power-bi/refresh-csv-file-onedrive

     

     

    Regards,

    Daniel He

     

v-danhe-msft's avatar
v-danhe-msft
Microsoft Employee
7 years ago

Hi Jan_Kalina,

Based on my research, you could upload your excel file on OneDrive or SharePoint Online,when you connect to your file on OneDrive or SharePoint Online, a dataset is created in Power BI. Data from the file is then imported into the dataset in Power BI. Power BI then automatically connects to the file and refreshes any changes with the dataset in Power BI. 

You could refer to below reference:

https://docs.microsoft.com/en-us/power-bi/refresh-csv-file-onedrive

 

 

Regards,

Daniel He