cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Failed Scheduled Refresh - Credentials are required to connect to the Python source.

Hello! I'm new to PowerBI and I installed a personal gateway in order to refresh csv files on onedrive. The csvs get data from an api (https://api.xyz.API-KEY=xyz&start_date=2018-08-08). I can refresh on demand, but when I want to do scheduled refreshes, I receive an error:

 

Underlying error code:-2147467259 Table: [DAILY] UK Promos [RESFRESH].
Underlying error message:Credentials are required to connect to the Python source. (Source at Python.)
DM_ErrorDetailNameCode_UnderlyingHResult:-2147467259
Microsoft.Data.Mashup.CredentialError.DataSourceKind:Python
Microsoft.Data.Mashup.CredentialError.DataSourcePath:Python
Microsoft.Data.Mashup.CredentialError.Reason:CredentialMissing
Microsoft.Data.Mashup.MashupSecurityException.DataSources:[{"kind":"Python","path":"Python"}]
Microsoft.Data.Mashup.MashupSecurityException.Reason:CredentialMissing
Cluster URI:WABI-US-NORTH-CENTRAL-redirect.analysis.windows.net
Activity ID:8eec04da-d7bc-447c-b4b5-e93ae10adee0
Request ID:411af470-a388-4b7f-9832-7fb0c08fe3ee
Time:2018-08-16 13:34:29Z

 

 

I use python to clean the data (under the "Run Python Script" button in the "Transform" ribbon), but I'm not sure:

  1. what that has to do with schedule refreshes
  2. where I'd put my credentials
  3. what my credentials would be

 

Also, the gateway connection shows a green check next to the personal gateway and there are no errors with the data source credentials.

 

Thanks in advance!

8 REPLIES 8
Highlighted
Community Support
Community Support

Re: Failed Scheduled Refresh - Credentials are required to connect to the Python source.

Hi @akinbimb

Do you directly connect to CSV file in Power BI Service and then configure OneDrive refresh or you firstly connect to CSV file from Power BI Desktop and then publish Power BI Desktop file to Service?

 

 

Best Regards

Maggie

Regular Visitor

Re: Failed Scheduled Refresh - Credentials are required to connect to the Python source.

Hi Maggie,

 

When I received these errors I was connecting to the CSV file from Power BI Desktop and then pulishing the .pbix file to Service.

 

I've also tried directly connecting to file #1 in Power BI Service, and OneDrive refresh is turned on. File #1 is listed under "datasets".

 

File #2 is listed under "Workbooks" and file #2 says "You can't schedule refresh for this dataset because one or more sources currently don't support refresh.

Discover Data Sources"(connecting directly to the files from PBI Service was suggested by this conversation).

 

Both file #1 and file #2 are excel csv worksheets on OneDrive that have a data connection to an API. The data returned from the API is refreshed weekly. What is the best way to keep the data in Power BI Service up-to-date? If the files are on OneDrive, can these files automatically refresh and get data from the API? Or would a macro have to be created for that? (I don't plan to ever open the csv files).Also, do you know where I would put python credentials?

Highlighted
Advocate II
Advocate II

Re: Failed Scheduled Refresh - Credentials are required to connect to the Python source.

Note that there is currently some issues with the service: https://powerbi.microsoft.com/en-us/support/

This could be causing your problem.

Highlighted
Regular Visitor

Re: Failed Scheduled Refresh - Credentials are required to connect to the Python source.

I'm still receiving an error, despite the fact that the Power BI Service outage has passed. When I try to load the report in a different way, I receive this error: 

Message:The import Python.Execute matches no exports. Did you miss a module reference? 

 

This issue has not been resolved.

Highlighted
Frequent Visitor

Re: Failed Scheduled Refresh - Credentials are required to connect to the Python source.

Hi akinbimb,

 

I am facing exactly the same issue. When refreshing the data on PBI desktop everything is ok. However, when I publish to Power BI Service the refresh fails with the message: The import Python.Execute matches no exports.

 

Did you manage to overcome this problem?

 

Thanks in advance.

Highlighted
New Member

Re: Failed Scheduled Refresh - Credentials are required to connect to the Python source.

Any resolution to this topic.  I am having the same issue.  The scheduled refresh fails on the python script via DMG.

Highlighted
Frequent Visitor

Re: Failed Scheduled Refresh - Credentials are required to connect to the Python source.

InstantNemesis, I have received a contact from Microsoft support saying that Python is Preview Feature so far.

Which means that it doesn't work so far on Power BI services!

Maybe next version... let's see!

Highlighted
Regular Visitor

Re: Failed Scheduled Refresh - Credentials are required to connect to the Python source.

Hi @InstantNemesis, what wlewicki said is true -- PBI Engineering + Support team responded to me via Email and Skype ultimately saying that Python is not supported on PBI Server.

 

My bad @wlewicki for not seeing your previous post!!

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors