Hi Everyone,
I'm mostly just looking for general advice to point me in the right direction. I don't even know what to Google or if I am just completely unaware of some features PowerBI has.
The scenario at my organization is this: I have a large Excel file from another team saved down in .xlsb format instead of .xlsx in order to reduce file size (it's about 31 MB right now in .xlsb). I need to use PowerBI to make a dashboard to generate reports off of this file, but like this article states here , I am running into severe performance issues of powerbi being really slow, and I don't even think it is recognizing all the columns of data. I took the article's advice and built a macro that will scrape all the data I need and save it down in a .xlsm version, which PowerBI is reading fine.
So right now I have: Source Data ------------> Macro -------------> PowerBI
The issue is i'll have about 15 people that will need to look at the dashboard I made in PowerBI. All of them will be looking at the dashboard with different data to generate reports. I don't think they can share 1 dashboard because they will all want to use different data and different filters. They also may want to see how things look when they try out different numbers and refreshing the dashboard, so I don't think all 15 people can share the single macro file. To me that means that each person will need their own macro to collect the data as well as their own powerbi file because I'll need one separate powerbi file to establish a connection for each macro.
So if I go with this plan, it will look like this: Source Data -------------> Macro (x15) ------------------ PowerBI (x15)
I can take my pb file and then copy it 15 times, but then I'll also have to update the source file being read in from power query because there would be 15 different macros. The problem is if I have to make any updates, it would be a lot of manual work - either make the same edits to all 15 pb files or make 1 change to a master file, copy it 15 times, and update the data source file in power query again.
So I was just wondering if this is the best way to proceed? Or does PowerBI offer other options for when 15 people all with different data need to use my dashboard? Is there like a way I can have dashboard with some sort of upload file box, and all 15 people can download the dashboard to their own comptuer, drop their own file into it, and then see how it looks?
Thanks!
