Forum Discussion
Helper IPower BI Model
Helper ISamarth_18 Thank you.
Yes these are actually adopted.
But on top of this the visualization break.
Issue 1:
We have the below approach
Database ---> Dataset(shared) ----> Multiple Visual/Report
The idea is that there are many reports which needs same data set and hence we came up with above.
But on this, the visualization seems to be breaking (cant show the view error) or its very very slow.
When trying Import mode for each report i.e. Database ---> dataset + Visual , it seems to be working fine. But we do not want this approach as there are 10s of reports which will hit the DB that many number of times for same table.
Issue 2:
I see the query from the PBI is nomore in the database. But still the PBI refresh says in Progress. Few days it gets over in 30 mins and few days it keeps running for 2+ hours but no query in DB. Not sure if there are ways in the PBI service where we can track the query/whats in progress with the dataset
Hi ddfreedie,
#1, AFAIK, these query tables are different instances (power bi will create multiple query tables with data connector to get data from different database tables) so power bi will send requests multiple times.
For this scenario, you can try to get the table list from your database then create refer query tables to refer subtables from the main table records.
#2, I'd like to suggest you check the database logs about power bi request sessions and correspond operations to get further information.
Session Tracing (SAP Library - Administration Manual)
Displaying Logs and Traces (sap.com)
Regards,
Xiaoxin Sheng