cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

one dashboard for multi users and multi databases of the same schema

hi 🙂

 

I have 9 databases with the same schema for 9 clients that all sign in my web applicaiton and every one see his data by a reports build by me in asp.net

 

Now after I see power BI I wonder if I can design just one dashboard for one of the databases then every user login will see his / here data on that dashboard?

 

9 REPLIES 9
Highlighted
Microsoft
Microsoft

Re: one dashboard for multi users and multi databases of the same schema

Hi @helixabdu,

 

It seems your scenario is App Owns Data. I don't think that is a good idea. 

1. Since there is only one report (one dataset), there will be collisions when more than one customer login. For instance, Customer A logs in and asks to load data and then Customer B logs in and also do the same thing. Related API: power-bi/datasets/updatedatasources.

2. Since there are 9 databases, the performance will be bad if the customer switches the database back to the customer's and reload all the data. 

 

The workaround could be using one database and applying RLS. Please refer to power-bi/service-admin-rls.

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Regular Visitor

Re: one dashboard for multi users and multi databases of the same schema

Hi @v-jiascu-msft

 

Thanks for the clarification and the links.

 

actually putting all data in one Databases can not be done for now and the number of databases may increases in the future.

 

so can I create a Data-set for each Database, then when user connect I just connect the dashboard to that data-set to view his/here data?

Highlighted
New Member

Re: one dashboard for multi users and multi databases of the same schema

Just chiming in. How granular is the data that it can't be consolidated into one database? Also if it's very granular how about aggregating it? You're gonna have to do some sort of aggregation in power BI anyway. As the previous person said, you can then add in RLS to filter the data for specific users. It's probably even much more managebale and better architecture this way tbh.

Highlighted
Microsoft
Microsoft

Re: one dashboard for multi users and multi databases of the same schema

Hi @helixabdu,

 

Since one dashboard or one report won't help in your scenario, I would suggest you create one Dataset for each Database. Though we can bring all data into one Dataset in Power BI, it isn't convenient. For example, the performance will be good for small dataset. Refresh of Dataset could be faster.

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Regular Visitor

Re: one dashboard for multi users and multi databases of the same schema

Hi @v-jiascu-msft

 

I will be more clear this time may be I'm asking the wrong question 🙂

 

we have an Accountant+Storage+POS all in one system that work off line on client desktop .. there are Items Table ,Bills Table ,Transactions Table , Accounts Table .. etc . we have about 6,000 client some of the clients need to see the reports on-line without going to there store or ask there employee to send them reports by email.

 

so I start work with 9 of them on that I upload some of there data on my server then start display the reports for them by using some APIs and Javascrip reports .. all I do is change the database name in the connection string when a client log in to the website and all of them can share the same design of the reports and dashboard and display data of them.

 

now I need to move to Power BI because adding new reports and designing them are much easy than using javascript with APIs

 

so what is the possibles to achieve the same as I have with PowerBI

 

Note:

- some of my clients have data of more than one million recored for some tables.

- Some of the reports can be filtered by the clients as they need by some filter controls I added like selecting a date [from] [to].

Highlighted
Regular Visitor

Re: one dashboard for multi users and multi databases of the same schema

Hi @v-jiascu-msft

 

I will be more clear this time may be I'm asking the wrong question 🙂

 

we have an Accountant+Storage+POS all in one system that work off line on client desktop .. there are Items Table ,Bills Table ,Transactions Table , Accounts Table .. etc . we have about 6,000 client some of the clients need to see the reports on-line without going to there store or ask there employee to send them reports by email.

 

so I start work with 9 of them on that I upload some of there data on my server then start display the reports for them by using some APIs and Javascrip reports .. all I do is change the database name in the connection string when a client log in to the website and all of them can share the same design of the reports and dashboard and display data of them.

 

now I need to move to Power BI because adding new reports and designing them are much easy than using javascript with APIs

 

so what is the possibles to achieve the same as I have with PowerBI

 

Note:

- some of my clients have data of more than one million recored for some tables.

- Some of the reports can be filtered by the clients as they need by some filter controls I added like selecting a date [from] [to].

Highlighted
Regular Visitor

Re: one dashboard for multi users and multi databases of the same schema

Hi @v-jiascu-msft

 

I will be more clear this time may be I'm asking the wrong question 🙂 🙂

 

we have an (Accountant + Storage + POS) all in (one system one Database) that work off line on client desktop

there are Items Table ,Bills Table ,Transactions Table , Accounts Table .. etc .

 

we have about 6,000 client some of the clients need to see the reports on-line without going to there store or ask there employee to send them reports by email.

 

so I start work with 9 of them on that .. I upload some of there data on a server then start display the reports for them by using some APIs and Javascrip .. all I do is change the database name in the connection string when a client log in to the website and all of them can share the same design of the reports and dashboard and display a data of them.

 

 

now I need to move to Power BI because adding new reports and designing them are much easy than using javascript with APIs

 

so what is the possibles to achieve the same as I have with PowerBI

 

Note:

- some of my clients have data of more than one million recored for some tables.

- Some of the reports can be filtered by the clients as they need by some filter controls I added like selecting a date [from] [to].

Highlighted
Microsoft
Microsoft

Re: one dashboard for multi users and multi databases of the same schema

Hi @helixabdu,

 

Let's see, do you really have 6000 databases or tables?

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Regular Visitor

Re: one dashboard for multi users and multi databases of the same schema

Hi @v-jiascu-msft

 

No I have 6,000 clients and that mean some client have more than one store .. each store have one database or more (there is an option that can open new databases for every new year)

 

so the real number of databases are more than 10,000 databases.

 

but not all of them need to see their reports online just the clients that on abroad and need to follow up with their store

 

for now I have 9 clients each one with one databases

 

my current solution of asp that I host it on an azure VM and the databases with a sql pool it is work and fine, but adding new reports every time is take long time to create API optimize the "Select Query" then connect it to a Jason report and every report and design need its own schema and that just pain and need time.

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors