Sample data for Power BI app template

[ArtemKlo]

Hi everyone, I have a report and data set that consists of 2 data sources - Business Central (standard connector, 1 entity) and SQL server -1 table. I need to create a power bi app template, but  i don't have sample data for it in these sources. All data in sources is real. One of the requirements for app is that user should have possibility to connect to their own databases (I made it through parameters). How can I add sample data to the app via other sources, so that these sources are not available in the app after installation? I tried to create files with masked data in Excel, then add them to Dataset, create parameters that switch sources from real to excel files, publish this report to app with masked data from excel, and allow for users only use parameter with real DataSource, when they connect their sources. But app require authorization for users for Excell files even if the data is not used by them. 

[GilbertQ · Accepted solution]

Hi @ArtemKlo 

The only thing I can think of is for you to either create a demo site and tables to get this working or you could mask the existing data and just create a small subset of the data.