Like what you see? Discover the benefits of the D365UG/AXUG Community. Learn More
In power BI, Row-level security (RLS) can be used to restrict data access for given users. We can also set up filters restrict data at the row level at the time of development. An Admin can restrict data every user's persmissions. https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-rls/
When DirectQuery method is used for data connection-requests are sent to the source database, the time required to refresh a visual is dependent on how long that back-end source takes to respond with the results from the query (or queries). The recommended response time (with requested data being returned) for using DirectQuery for visuals is five seconds or less, with a maximum recommended results response time of 30 seconds. Any longer, and the experience of a user consuming the report becomes unacceptably poor. In addition, once a report is published to the Power BI service, any query that takes longer than a few minutes will timeout, and the user will receive an error. So the database will not get locked for large amounts of time.
When a query in DirectQuery retrieves excessively large number of rows (more than 1 million) from the back-end data source, in which case the following error occurs: The resultset of a query to external data source has exceeded the maximum allowed size of '1000000' rows.
Row Level Security (RLS) can have a significant impact as it increases the load on the source database and potentially impacting performance
With help of content packs in Power BI users can copy the original dashboard/reports and makes changes accordingly. These changes will then be Unique to that user.
We can set up queries in AX to deal with both normalized data and complex structures like DirParty. It would work just like a query SSRS Report but the Report will be hosted on POWER BI.
Create a new dimension table with a list of possible set of constants for the Enum values and merge with the respective fact table.
This thread has had a number of responses, BI seems to be a hot topic.As part of the AXUG, I'll be presenting a webinar: "AX 2012 BI/Reporting – How to Start Simple – Getting the Data Right" on August 8 at 11 AM EDT. We'll discuss some of the concerns we encountered related to BI and discuss/present the approach our company has used to model our data and create a simple approach to reporting in AX 2012. We will also go over some of the issues we encountered and our future plans.You can register for the event here. Look forward to your participation.
Site designed by Brightfind
Powered by Cobalt xRM and Higher Logic