Forum Discussion
Use data model in different PowerBI files
Hello all,
My data model consists on 4 csv's linked together and one date table. I linked everything on PowerBI. I have all the connections prepared so they are very easy to update. The thing is that I have to present different dashboards for different people with the same data.
My question is, without making the model too complex: can I link PowerBI files to data models of other PowerBI files? So the connections look like this:
Raw Data > PowerBI file with data model > Different PowerBI files, each with different pages for Marketing, sales, etc
3 Replies
Not sure I got it. You can bring data together, which you need to analyze together and create a model around common dimensions
https://docs.microsoft.com/en-us/power-bi/guidance/
I usually create pdfs for different parts of the company.
If I have separate powerbi files I can create separate pdfs very easily. But the thing is that now I have separate powerbi files with each having a similar data model. What I want is to have one data model and being able to share it with the other powerbi files
Hi,
you can publish your data model powerbi file to the Power BI Service, and then create additional reports, which are connected directly to that data model. Use the Connect to Power BI Service from Get Data for each of the reports.
If you are doing this to create virtually identical reports on the same data, just for the purpose of creating pdfs, then I would try creating bookmarks in one report to give you sifferent perspectives, and then export each pdf once you have filtered the main report.
