Using Power BI Desktop in Live Connect to SSAS Tabular

[Rob1]

Hi All,

We are trying to put in Power BI in using Live Connect connecting to our SSAS tabular semantic model. I don't quite have the understanding on a few points:

1. If we are trying to create a number of PowerBI reports using the same Fact table but will have different criteria, how can we do so with bringing in the Fact table everytime?

2. If the answer is to put int multiple Partitions of the Fact table in the model, how can I get Power BI in Live Connect to use a certain partition for my report?

3. If the answer is to create a representative table in the model per report won't that bloat the memory of the SSAS model?

Thanks,

Rob

[Anonymous]

Hi @Rob1 ,

You can achieve it by using a shared dataset  or creating dataflow, please find the following links for more details.

How to use same dataset for multiple report?

You can look into using Power BI Dataflows, or you can use the Shared Datasets which is in preview now.

Power BI Dataflows

Shared Datasets (Preview)

When connecting to these data sets from Power BI Desktop, either choose:

Get Data -> Power BI datasets

or

Get Data -> Power BI dataflows

---

5 Tips for Separating Power BI Datasets and Reports

In addition, you can try the method in the following thread to get it.

One dataset for multiple reports (Apply RLS)

Best Regards

[amitchandak · Accepted solution]

@Rob1 ,

If we are trying to create a number of PowerBI reports using the same Fact table but will have different criteria, how can we do so with bringing in the Fact table everytime?

you can use Slicer or page level or report level filter. is that not an option ?