Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I was going through the follwing post and then got a question. How do we clear the data from the power BI file and keep only the definition?
Regards...
Solved! Go to Solution.
If you are running an import query, the data is all stored in the .pbix file. There is no way to run the queries without having the data in the file. If on the other hand you are using the Direct Query method on a SQL database, that data is only pulled by the file on demand and is not stored locally within it. So unless you are doing a Direct Query against a SQL database, you cannot clear the data from the file and still maintain working queries.
Proud to be a Super User!
Well, if you just want the structure and no data. Create a view for the data you need to collect. Alter view to select top x so the import only loads the top x. Dont forget to remove the top x when your done.
Save the file as a .pbit - A PowerBI Template.
this doesn't work, the template is totaly empty and contains nothing
If you are running an import query, the data is all stored in the .pbix file. There is no way to run the queries without having the data in the file. If on the other hand you are using the Direct Query method on a SQL database, that data is only pulled by the file on demand and is not stored locally within it. So unless you are doing a Direct Query against a SQL database, you cannot clear the data from the file and still maintain working queries.
Proud to be a Super User!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |