topic Re: Embedded report app flask in Developer

Embedded report app flask

apenaranda — Fri, 15 Sep 2023 12:11:14 GMT

I have an application with Flask where I embed reports, I get a list of reports (I save the id in a database) and later it makes me embedded the one I select, locally I don't get any errors and it shows me the id value of the selected report , when I upload the application to my website, then it is as if the ids remain in cache for a while because I select 1 but it shows me another, normally the previous one seen, as if something remained in cache and it reloaded what was before .
Has it happened to anyone?

Re: Embedded report app flask

apenaranda — Mon, 18 Sep 2023 06:13:44 GMT

I also added that the embedded query to the reports is done through a single user, all users access to view the embedded report through a single user with a power bi license.

Re: Embedded report app flask

Anonymous — Tue, 19 Sep 2023 01:57:46 GMT

HI @apenaranda,

What type of embedded are you means? Power bi embedded or 'publish to web'? If you mean the 'publish to web', it include the delay between source report and embedded report.

Publish to web from Power BI - Power BI | Microsoft Learn

If you are working with dataset with large amount of records. They should also cause the refresh delay.

Regards,

Xiaoxin Sheng

Re: Embedded report app flask

apenaranda — Wed, 20 Sep 2023 05:38:18 GMT

I do not publish on the web, I use APIs, in this case Python, to view the reports through embedded licenses.
What I do in my python app is that I have the ids of the reports in a mysql table and I make the query according to user and report. What I see in the console is the app on localhost and it works well, the query is done correctly and it calls the correct id. When I publish the app on the web, no longer, it's as if it keeps the previous/previous id in cache or something like that and it shows you the one it wants, although the query is done correctly and it should show the id of the query... very strange thing indeed.

Re: Embedded report app flask

Anonymous — Thu, 21 Sep 2023 08:36:10 GMT

Hi @apenaranda,

How many rows the data source table stored? Did power bi service tenant and embedded environment host on the same data regions? They may case the additional cost of refresh and cause the delay of data refreshed.

Regards,

Xiaoxin Sheng

Re: Embedded report app flask

apenaranda — Fri, 22 Sep 2023 04:59:46 GMT

Finally I solved it by modifying the jquery that creates the embed and passes the data, for some unknown reason it sent some correct data locally and others on the web. Now I collect the value from the template so that it has the values correctly from the beginning.
Greetings,