Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
BonneyCBS
New Member

Python Script - Data Gateway - No Option to Use Data Gateway for Data Source

Hi, I have a python script that PowerBI uses as a data source. According to what I've read it should be possible to refresh this data source in powerbi service using a personal gateway. 

 

So, I have a personal gateway installed. 

BonneyCBS_1-1642872920165.png

 

 

Its working for a simple excel data import that I did as a test.

 

BonneyCBS_2-1642873022955.png

 

But for the data source with the python script i get the following error.

 

BonneyCBS_3-1642873107739.png

You can't schedule refresh for this dataset because the following data sources currently don't support refresh:
Data source for Query1

 

Updating the data source in PowerBI Desktop works fine.

The script basically does the following: Python(Requests) Scrape Website -> Pandas DataFrame(s) Import PowerBI

 

Any ideas how I could fix this?

 

1 ACCEPTED SOLUTION
BonneyCBS
New Member

I managed to get it fixed, the simplest things sometimes. Needed to press the discover data source

BonneyCBS_0-1642879501896.png

 

View solution in original post

1 REPLY 1
BonneyCBS
New Member

I managed to get it fixed, the simplest things sometimes. Needed to press the discover data source

BonneyCBS_0-1642879501896.png

 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors