A Power BI file that consolidates tables prepared using M language from multiple extensive Power BI

[Ironakat]

Hello, I need your help. I have a simple task and I'm totally stuck. Could you please guide me on how to create a Power BI file that consolidates tables prepared using M language from multiple extensive Power BI files? If MS fabric works, could you please tell me which one I should use? Thank you.

[Idrissshatila · Accepted solution]

Hello @Ironakat ,

So if I did understand your point, you want this file to be used to create new reports. then you publish this datset to service then you create a new power bi file and connect to power bi dataset.

check this concept out https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea 💡

[Ironakat]

Hello @Idrissshatila,

Thank you for your message. But I would like to controle each of those extensive Power BI files, since those have been used in the business already.  I would like to have a Power BI file to import tables prepared by using M language from those existing Power BI files. Thank you.

[Idrissshatila · Accepted solution]

Hello @Ironakat ,

So if I did understand your point, you want this file to be used to create new reports. then you publish this datset to service then you create a new power bi file and connect to power bi dataset.

check this concept out https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea 💡

[Ironakat · Accepted solution]

Thank you much for the link!  I verified it works perfectly!

[Idrissshatila]

Hello @Ironakat ,

If you want to have them all in one table above each others then you use append

https://learn.microsoft.com/en-us/power-query/append-queries

if you want to add the columns alogside each others you use merge queries

https://learn.microsoft.com/en-us/power-query/merge-queries-overview

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea 💡