Dataverse and PowerBI

[Anonymous]

I need few advices.

We have built a code-free app(not Power app) that stores its data into SharePoint Online lists(5 lists). SharePoint online does not serve as DB per say for us, but rather it allows users to refine the data with the app until the data i ready to be converted into PDF document.
We have been asked to design a dashboard based on some of this data. Only data meeting certain criteria would be included in the report. My idea is to create and environment and Datavese DB and import the data from SP and then use it for PowerBI. Then have the app send data to Datavrse when user submits a report(or under some other condition). Even though data is split across the lists in SP, most of the data is in 1 to 1 relationship, so a single entity(table) appears to be sufficient.

Questions:
1. Is having data in Dataverse Entety in order to build a Power BI dashboard a good choice. Can I build reports by connecting report to Dataverse only?
2. Will i have problems getting data from 5 SP lits into a single Dataverse entity?
3. If there are no 1 to Many; Many to Many relationships in the data, should I keep the data in the single table in Dataverse for the purpose of PowerBI reports.

 
If I am architecturally on the wrong track, please direct me in the right way. Thanks

[v-alq-msft · Accepted solution]

Hi, @Anonymous 

1. According to the document , you can create a Power bI report using data from Dataverse.

2. I don't think it will have problems getting data from 5 SP lits into a single Dataverse entity.

3. When possible, it is suggested to avoid creating one-to-one model relationships when row data spans across model tables. It's because this design can:

• Contribute to Fields pane clutter, listing more tables than necessary
• Make it difficult for report authors to find related fields, because they're distributed across multiple tables
• Limit the ability to create hierarchies, as their levels must be based on columns from the same table
• Produce unexpected results when there isn't a complete match of rows between the tables

Specific recommendations differ depending on whether the one-to-one relationship is intra source group or cross source group. For more information about relationship evaluation, see Model relationships in Power BI Desktop (Relationship evaluation).

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.