Forum Discussion
Power BI Model
Samarth_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
Issue 1:- you can try to implement data flows where you can put all the big tables in dataflows and import that dataflows to your reports so instead of refreshing it from 10 reports you just need to refresh 1 dataflow and all report will have latest update.
Issue 2:- You can enable performance analyzer and can check which table or column having issue.