Forum Discussion

jdalessio1's avatar
jdalessio1
New Member
1 year ago
Solved

Change data source from datamart to another powerbi source

Hello everyone,   I need some expert help for this big problem.   So, I have this datamart in pbi service with more or less 70 tables in it and it is used by almost 50 reports (the company used m...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi jdalessio1,

     

    Thank you for reaching out to Microsoft Fabric Community Forum.

     

    Switching from Datamart to a Warehouse is a smart move, considering Datamarts have limitations and an uncertain future.
    The best way to handle the transition is to use a combination of Lakehouse + Warehouse for better scalability and integration.

    If API is not an option, you will need to manually update the data source in Power Query for each report.

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!


    Regards,
    Vinay Pabbu

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi jdalessio1,

 

Thank you for reaching out to Microsoft Fabric Community Forum.

 

Switching from Datamart to a Warehouse is a smart move, considering Datamarts have limitations and an uncertain future.
The best way to handle the transition is to use a combination of Lakehouse + Warehouse for better scalability and integration.

If API is not an option, you will need to manually update the data source in Power Query for each report.

 

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!


Regards,
Vinay Pabbu