How do I use Power BI Desktop with version control

0 votes

I am building a series of power bi dashboards, and as they go into production I'd like to put them into TFS. However, due to the large datasets involved, some of these report definitions are quite large (1.6GB).

It doesn't seem like a good idea to force TFS to store all of the actual data, when only the definition really matters.

Is there a simple way to remove the data from a .pbix file or save only the definition?

Dec 18, 2020 in Power BI by Rajiv
• 8,870 points
785 views

1 answer to this question.

0 votes

I would add a "Parameters" Query (a table with a single row - created using Edit Queries / Edit Data) with a column called [Data Load], with a single row containing "Yes".

Then I would add a Filter step to the end of all the other Queries, referring to that "Parameters" Query. The Filter syntax would be:

Parameters{0}[Data Load] = "Yes"

That syntax is a bit obscure - it means:

Go to the Parameters Query, get the value from the 1st row, in the [Data Load] column, test if it equals "Yes".

When you want to empty all the data from the .pbix file, edit the Source step in the "Parameters" Query and change the [Data Load] value to "No", Apply and Refresh.

I've built a working example of this which you can download from my OneDrive and try out:

answered Dec 18, 2020 by Gitika
• 65,770 points

Related Questions In Power BI

0 votes
1 answer

How do I use Python Visualizations in Power BI?

Hi, You can create interactive reports out of ...READ MORE

answered Apr 8, 2019 in Power BI by Phalguni
• 1,020 points
996 views
0 votes
1 answer

How do you use R visuals in Power BI Desktop?

Hi, In order to use R Visuals you ...READ MORE

answered Apr 10, 2019 in Power BI by Avantika
• 1,520 points
728 views
0 votes
1 answer

How do I use Python scripts in Power BI?

Hi, You can create interactive reports out of ...READ MORE

answered May 2, 2019 in Power BI by Avantika
• 1,520 points
2,441 views
0 votes
1 answer

how do i publish to azure on power BI desktop?

To publish a Power BI Desktop dataset ...READ MORE

answered Oct 30 in Power BI by Evanjalin
• 7,890 points
61 views
0 votes
1 answer

Install Power BI Desktop

It’s a pretty simple process. All you ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 52,350 points
1,070 views
0 votes
1 answer

Few tips before I start creating Power BI dashboard

It’s always advisable to begin with the data ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 52,350 points
905 views
0 votes
1 answer

How do I format the KPI in Power BI

format the KPI by selecting the paint ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 52,350 points
1,259 views
+1 vote
1 answer
0 votes
1 answer

I have a web API with basic authorisation and username and password. How do i connect to it in Power BI?

Hey, @There, I found your query is quite ...READ MORE

answered Oct 29, 2020 in Power BI by Gitika
• 65,770 points
3,627 views
0 votes
1 answer

How can I use Power BI on my Ubuntu machine

Hey, @Jublleevdsl, Based on my research, currently, it ...READ MORE

answered Nov 23, 2020 in Power BI by Gitika
• 65,770 points
7,179 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP