Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello, I am able to run the first script below in Jupyter but when I run it in python I get "the preview for section 1/query1/source doesn't exist".
I have checked my settings in PBI and have all the packages installed on my machine. In fact I am running a very similar script with the same definition successfully. However when I add the last 5 lines of code I get the error.
I read it could be the size of the output but the output is 300 rows with 2 columns.
Your help is greatly appreciated!
import stripe
import pandas as pd
from datetime import datetime
import numpy as np
stripe.api_key = ''
stripe.api_version = "2020-08-27"
df_lookup = pd.DataFrame(columns=['payout_id', 'charge_id'])
def stripe_get_data(resource, start_date=None, end_date=None, **kwargs):
if start_date:
# convert to unix timestamp
start_date = int(start_date.timestamp())
if end_date:
# convert to unix timestamp
end_date = int(end_date.timestamp())
resource_list = getattr(stripe, resource).list(limit=100, created={"gte": start_date,"lt": end_date}, **kwargs)
lst = []
for i in resource_list.auto_paging_iter():
lst.extend([i])
df = pd.DataFrame(lst)
if len(df) > 0:
df['created'] = pd.to_datetime(df['created'], unit='s')
return df
for i in stripe_get_data('Payout')['id'].tolist():
balance_transactions = stripe.BalanceTransaction.list(payout=i, expand=['data.source'], type='charge')
for txn in balance_transactions.data:
charge = txn.source
df_lookup = df_lookup.append({"payout_id":i,"charge_id":charge.id}, ignore_index = True)
Solved! Go to Solution.
@thomas9921 , Refer the old solution
Or refer to the steps and description of the video for various errors
How to make Python work with Power BI: https://youtu.be/5D0BkNsu5CM
@thomas9921 , Refer the old solution
Or refer to the steps and description of the video for various errors
How to make Python work with Power BI: https://youtu.be/5D0BkNsu5CM
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
82 | |
65 | |
63 | |
56 |
User | Count |
---|---|
171 | |
111 | |
110 | |
72 | |
71 |