Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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