Changing data source from SharePoint Lists to Dataverse.

Hi Class66Loco,

Thanks for reaching out to the Microsoft Fabric Forum Community.

Migrating a Power BI report from SharePoint Lists to Dataverse isn't just changing the data source URL it involves key differences in structure, relationships, and data types.

Checklist Key Points:
Check schema: Dataverse uses strict types and relationships; SPOL is flat and flexible.

Update queries: Power Query steps may need adjustments, especially for lookups or nested fields.

Rebuild relationships: Dataverse supports native relationships you may need to define.

Adjust DAX: Revisit measures and calculated columns using SharePoint-specific fields.

Test visuals and performance: Validate data accuracy and performance in the new setup.

It's usually not worth rebuilding from scratch unless the original report is messy or outdated.

If this helped, please mark the response as the accepted solution and give it a thumbs-up so others can benefit too.

Best regards,
Prasanna Kumar

Hi Class66Loco,

Just a gentle reminder  has your issue been resolved? If so, we’d be grateful if you could mark the solution that worked as Accepted Solution, or feel free to share your own if you found a different fix.

This not only closes the loop on your query but also helps others in the community solve similar issues faster.

Thank you for your time and feedback!

Best,

Prasanna Kumar