What is the best way to give Power BI file to customers?

[maelfosso]

Hi,

I am building a set of appliances for helping some people in their different activities. 

On top of that, I am proposing them to see some analysis that i am building using Power BI.

I am wondering what is the best way to give the Power BI to the user so that he couldn't see either the tables/data imported into Power BI or the different formula, measure that are used in the different graph.

Knowing also that, at this stage, I don't have money to pay for Premium, the users will only access to the internet to upload the data into Power BI.

By hoping that the description of my problem is clear,

Can you indicate me how to solve that?

[EmanuelTavares · Accepted solution]

Hi @maelfosso .

To solve this, you can create a file containing the database connections and metrics formulas and publish it in a workspace (you can do it using a Pro account, maybe a free one).

It will create an online semantic model. 

Then, you can develop the client's dashboard connecting to this dataset instead of the database itself.

In this case, the client's dashboard will not show the tables (just the relation diagram) or the metrics' formulas.

Select a Power BI semantic model as data sourceI selected the metric, but I can't see the formula. I don't have the option to see the data too.

You don't need to have a Premium account to do this.

IMPORTANT!

Since the client's dashboard is not connected to the original database, when you refresh its data, Power BI will read the data from the online semantic model, not from the original database.

To update the data, you need to update the semantic model and then update the dashboard.

Regards,

Emanuel