Multiple users accessing the same PowerBi report with different data sources?

Anonymous — Thu, 12 Sep 2019 21:14:15 GMT

Hi,

I'm creating a website with a PowerBI report embedded within it. It'll be accessed by different users and each user will upload an Excel document containing data unique to them (but in a standard format) and the report will display visualisations for that data.

Has anyone done anything like this in the past and can advise on how it's possible? I accept that I'll need to write a custom spreadsheet import routine on the site, but how would I reference this data source from the report?

The uploaded spreadsheets the users will import will all be in the same format, but obviously multiple users could be using the site at the same time, so the report they see needs to only display their data.

Can this be done?

Re: Multiple users accessing the same PowerBi report with different data sources?

JosefPrakljacic — Fri, 13 Sep 2019 06:09:18 GMT

Hey Nick,

what would I do in this case ->

All the excel uploads are in one Folder
You are querying/importing from that Folder to PowerBI
In one column there should be an userinfo (see next step why)
That userinfo can then be filtered. I don't know how you are handling the current userstate. In PowerBI Service (when Im not embedding) I use the USERPRINCIPALNAME Function to filter the data. In your case you could read through this documentation.

If this post was helpful may I ask you to mark it as solution and give it some kudos?

Have a nice day!

BR,
Josef

topic Re: Multiple users accessing the same PowerBi report with different data sources? in Developer

Multiple users accessing the same PowerBi report with different data sources?

Re: Multiple users accessing the same PowerBi report with different data sources?