Forum Discussion
Using Power BI Desktop in Live Connect to SSAS Tabular
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
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 ?
2 Replies
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 ?
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.
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
