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

Is this even possible? Split of Data Sources and Reports

(I apologise beforehand if this isnt the correct forum)

 

Hi all,


I'm looking for more information around PowerBI. Specifically around users extenral to our data team using the product. Scenario follows;

 

1) They wish for us to create data sources (multiple types) and deploy them to PowerBI as a data source - to manage/update daily etc.

2) From these, they then wish to create measures on demand, new reports etc. That will then use the data source outlined in step 1.

 

The issue;

 

1) Creating a data source from a database server is complete. The refresh is set to 9am daily.

2a) User creates report in PowerBI (on the web) and is unable to create measures.

2b) User downloads the data source pbix, creates report and new measures in PowerBI (Desktop) this then either overwrites the data source (causing issues where things have been changed) or creates another data source, that then needs to be configured for refresh etc).

 

Another additional point is through the use of the .pbix download - They are then able to navigate to other tables on the SQL server, effectivly looking where they should not be, as people exterior to the department.

 

Has anyone had exprience with similar issues? 

 

1 ACCEPTED SOLUTION

Accepted Solutions
KBO Member
Member

Re: Is this even possible? Split of Data Sources and Reports

Hi, I don't know If I understand the Problem correct but my suggetion is:

1) Create a Dataflow in which you can predefine (like in Power Query - beacause it is Power Query :D)

2) Create a Dataset with the different Entities from your Dataflow and build a nice schema including your measures (if you like) and don't build any visuals in it! Only the data including the schema (model)

3) Deploy the Dataset and give them a certified

4) Say to your Power User, If they want build a report please use the certiefied dataset and if you need new measures create them in your report (Power BI Desktop Client -Please use for building reports only the Desktop Client - the PBI Service is more for little changes). If the measures are relevant for all please tell us, we will add it to the dataset

 

Hope this helps?

 

Best Kathrin

View solution in original post

2 REPLIES 2
KBO Member
Member

Re: Is this even possible? Split of Data Sources and Reports

Hi, I don't know If I understand the Problem correct but my suggetion is:

1) Create a Dataflow in which you can predefine (like in Power Query - beacause it is Power Query :D)

2) Create a Dataset with the different Entities from your Dataflow and build a nice schema including your measures (if you like) and don't build any visuals in it! Only the data including the schema (model)

3) Deploy the Dataset and give them a certified

4) Say to your Power User, If they want build a report please use the certiefied dataset and if you need new measures create them in your report (Power BI Desktop Client -Please use for building reports only the Desktop Client - the PBI Service is more for little changes). If the measures are relevant for all please tell us, we will add it to the dataset

 

Hope this helps?

 

Best Kathrin

View solution in original post

JonaRogers Frequent Visitor
Frequent Visitor

Re: Is this even possible? Split of Data Sources and Reports

We'll try this - thank you.

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)