Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a Power BI report that pulls a csv file from a SharePoint site and then I use Python to transform the queried file using pandas library. On my desktop everythin works perfect. However, when I publish my report to the service and try to refresh the dataset either Manually or by scheduling. Refresh fails with the following error, "Scheduled refresh is disabled because at least one data source is missing credentials. To start the refresh again, go to this dataset's settings page and enter credentials for all data sources. Then reactivate scheduled refresh."
I even tried to use only python to generat a very simple dataframe from a blank query to narrow down the problem, the same issue happens again. I used this single line of code : df = pd.DataFrame({'col1':[1,2,3],'col2':[4,5,6],'col3':[7,8,9] })
The limitations of using a python script in the service isn't clear in the documentation. It only says "In just a few steps, you can run Python scripts and create a data model. From this model, you can create reports and share them on the Power BI service."
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @mnabil_cee ,
Totally agree with @klinejordan , please try using the personal gateway to see if it solves your problem.
Best Regards,
Community Support Team _ Caitlyn