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

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.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

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