NameError: name 'df_result' is not defined

[peya02]

Hello, I have copied the code to do some testing and it gives me an error in the NameError part: name 'df_result' is not defined. Did you mean: 'result'?

for index, row in df_result.iterrows():
    current_value = df_result['Fiscal Year'][index]
    body = {
        "format":"PDF",
        "paginatedReportConfiguration": {
            "parameterValues":[
                    {"name": "DateFiscalYear", "value": current_value}
                ]
        }
    }

    api_call = post_request(export_url, header, body)
    export_id = api_call.json()['id']
    export_id_list.append(export_id)
    parameter_value_list.append(current_value)

Do you know what it could be?

[CrasCris]

I think so, cuz he never define it, or he turn the result dict into a dataframe, did you solve it ?

Yep he did in the blog

[peya02]

Hello, I didn't get it, but I see that I don't have the part you indicate. Is the full code available? I want to implement it in an application that I already have in python - flask
thank you.

[CrasCris]

Hello, I didn't get it, but I see that I don't have the part you indicate. Is the full code available? I want to implement it in an application that I already have in python - flask thank you.

i didn't do it yet, as soon as i done it, i will post it, i'm doing with Flask as well

[peya02]

Okay perfect, I will be attentive to your publication. Thank you.

[CrasCris]

Okay perfect, I will be attentive to your publication. Thank you.

I try it, but you need to have a Premium Licence, this repo can embedding the report https://github.com/microsoft/PowerBI-Developer-Samples, but the export of the model as the format you want you need the licence

[peya02]

That repository is exactly the one I use, I modified it a little to my liking but basically it is the structure. But the issue that drives me a little crazy is exporting to PDF, yes I have managed to export but basically what it does is like a "screenshot", if for example you have a table with many records in the report, having the slider table, those final values will be left out of the capture.

[CrasCris]

I didn't know that, the "screenshot", is a liquid PDF ?

[peya02]

I don't know what you mean by liquid PDF, but what I have tried through this website is that it takes a screenshot of what you see at that moment and converts it to PDF.

https://learn.microsoft.com/en-us/rest/api/power-bi/reports/export-to-file-in-group?tryIt=true&source=docs#code-try-0

[peya02]

I am attaching an image of what could be a power bi table, as it has many rows and columns, not all of them appear, because the API takes a screenshot of what is being seen at that moment and passes it to you in PDF, leaving the rows/columns that are not being seen.

[CrasCris]

I see , thanks for help , i try it, but i dont have the licence so i get this

[CrasCris]

If you try CSV format, Did you get all the data in the visuals ?

[peya02]

I have not tried it although you can now get csv directly from the options of the power bi table itself.

[CrasCris]

I have not tried it although you can now get csv directly from the options of the power bi table itself.

I need the information of the report, so i dont mind if in csv format, can you show me the code to export the report ? i have tried with the but i only get a 403 error , i dont know , if i'm doing it right

[peya02]

To export to csv there is no code, you can do it from the power bi desktop table itself

[CrasCris]

To export to csv there is no code, you can do it from the power bi desktop table itself

D you know how it looks when you export to csv a paginated report ?, i need to fetch the data per season to use a LLM chat and ask questions about the report, i can do it myself for a local report but i need to do with a automatics script