using Publish to public web

Hi GMkk 

Given that you're connecting to Analysis Services, creating a new tabular model with just the necessary data on a different server is indeed a good approach. This allows you to maintain a clear separation between your internal, sensitive data and the data you wish to share publicly. It also provides an added layer of security, as any potential vulnerabilities or attacks would be limited to the public-facing dataset and not your main data warehouse or Analysis Services.

For more insights on separating your data model from your reports for public sharing, you might find the guidance on Report separate from model helpful.

In summary, while Publish to web is a powerful feature for sharing insights broadly, it's crucial to approach it with caution, ensuring that only non-sensitive data is made public. Creating a separate, sanitized dataset for public reports is a best practice that can help mitigate risks.

If you have any more questions or need further assistance, feel free to ask.

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.