cube
4 TopicsIdentify DAX Measures consuming too long to process
I have a tabular model on Visual Studio where data size is normal. It use to take 35-40 min to refresh 1 month back but someone added/modified few DAX Measures. Since then it is taking too long too refresh data. I want to indentify measures which are causing this issue. I have used these measures in Power BI reports too. How can I findout these measures so my model can be efficient and start refreshing normally.Solved1.5KViews0likes4CommentsRelationship between these two fact tables?
Hi, ich have on one side a wager. That is my first fact_wagers. It has attributes like: wager_id first_product_id second_product_id One the other hand I have a fact for the winnings: fact_wins. This occurs later than the wager got created. It has attributes like: wager_id win_amount product_id The relationship between them is 1:n , because one wager could have multiple winnings, because of his first and second product. One win in the first_product is related to one row in the winnings. A win in the second_product creates another row. How would you join those facts? Make a dim_wager_id as a degenerated dimension, because I would need that for filtering? CheersSolved1.3KViews0likes3CommentsReportServer Catalog table showing modifiedby users who shouldn't be able to
I've started noticing catalog records that are showing modified by users who don't have permission. I've isolated it to Dashboards with SSAS connections, but outside of that I'm not sure why these users are showing up. Thanks1.6KViews0likes2CommentsSchedule Refresh : sharepoint list and Cube datasource not working
Hi Community I have an issue with schedule Refresh on a PowerBI Report Server . Actually, I am connecting my pbix to both two different data source : sharepoint list (url) and a cube (direct query) I have creaed a scheduled refresh and I can see that it is finished wiht success = > Data REfresh completed However, the data was not refresh :( I have to downlaod the file locally, refresh it manually and then deploy it on the server. Is there a limitation of sharepoint list? If yes why did not receive an error message? Is there any workarround ? Any help will be appreciated. Thanks and Regards Asma549Views0likes0Comments