Forum Discussion
Super UserHow to publish power bi without data?
Yes, you can use parameters to indicate if all rows should be read or 0 rows should be read. You cannot not read, because power query needs the meta data.
Super UserSounds good. What have you tried and where are you stuck? You can also connect to a SQL data source and say "Select top 0 * from table" so that the meta data is filled but the data is missing.
Super Userlbendlin I tried these steps. And they are working, but my concern is that I will publish something with data and after that I will update parameters and the process can be broken - it means that published, initial data will be available for customer which I do not want to!
So following your thinking. Maybe i should have parameter like "No Data" and if this is chosen on local version - it should remove all rows within power query and keep only table headers.
Can you please confirm that it can be a potential solution?
Best Wishes,
Jacek
- lbendlin
Yes, you can use parameters to indicate if all rows should be read or 0 rows should be read. You cannot not read, because power query needs the meta data.
- jaryszek
Thanks. What is fragile here that if user will download report before i will update parameters he could change parameter manually (because power bi user belongs to Customer Tenant) and see all data if conection string was there.
Best,
Jacek
SaiTejaTalasilaHi jaryszek ,
If you have premium workspace s.Use deployment pipeline and provide access to only prod workspace and don't provide access to dev/test workspace.
I hope it will be helpful.
Thanks,
Sai Teja
- jaryszek
Thanks. What is fragile here that if user will download report before i will update parameters he could change parameter manually (because power bi user belongs to Customer Tenant) and see all data if conection string was there.
Best,
Jacek