Hello, I am pretty new on power Bi and Python, I am trying to use a scrip to read around 300 excel files and append or concat them but once those file have been appended, 99% of the time I wont need to read them again so just in case I did a scrip with a check box that let me decide if I want or not to read again all historical data, It works on anaconda notebook but when I try to run it in Power BI I got
Details: "ADO.NET: Python script error.
<pi>NameError: name 'display' is not defined
</pi>"
The Script :
import ipywidgets as widgets
import os
import pandas as pd
import glob
path_data=r'C:\Users\xxxxx\Desktop\All'
check=widgets.Checkbox(value=False,
description='Refresh Historic Data',
disabled=False,
indent=False)
display(check)
if check.value ==False:
path_data=r'C:\Users\m0188842\Desktop\All\1'
elif check.value ==True:
path_data=r'C:\Users\m0188842\Desktop\All'
os.chdir(path_data)
filenames = glob.glob('*.xlsm*')
df_final = pd.DataFrame()
for file in filenames:
df = pd.read_excel(file, sheet_name='Consolidation')
df_final=pd.concat([df,df_final],ignore_index=True)
df_final.to_csv(os.path.join(path_data, 'Test1.csv'), index=False)
The question is Can I sue widgets on Power Bi?
Thank you!
