There is one PowerBI solution. End users want to refer only to their own DB data

[Yoshihide]

Collect Microsoft Teams logs in SQLServer.

Create one solution that you can analyze with PowerBI.

I want to deploy a solution to multiple companies.

We will prepare one database for each company.

End users can only see DB data from their own company.

Data from other companies cannot be referenced.

Automatically select the DB when using PowerBI.

Can it be implemented?

To get here, I've tried.

I was able to parameterize the database name.

I think it would be good if the database name could be set as a parameter for each end user.

But I don't know how to pass the database name to the parameter.

My way of thinking may be wrong

Please let me know. Please.

[speedramps · Accepted solution]

Please click here for video lesson how to do it 

Thanks for reaching out for help.

I have helped you, now please help me by giving kudos.

Remeber we are unpaid volunteers.

Click the thumbs up and accept as solution button. 

One question per ticket please. If you need to extend your request then please raise a new ticket.

You will get a quicker response and each volnteer solver will get the kudos they deserve. Thank you ! 😀

[Yoshihide]

Thank you very much.

The video you contacted was great.

I understand that the database name can be a parameter.

So how can you specify the parameters?
I want to do this automatically for each user.

I am creating a new question.
If you find one, please answer it as well.

I look forward to working with you.