I have developed some SSAS tabular models and connected Power BI to them with a live connection.
My GM now would like to put some of this data out there for the public to view and interact with it. I know that you cannot publish to web a PBI file that has a SSAS Live Connection. So I am after some guidance on how to proceed.
- Do I import the SSAS Tabular model into a new PBI file and then use that data?
- Do I import the source tables from our datawarehouse and build the model again within the PBI file?
- Some other option?
Some guidance on this would be appreciated.