Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
6DiegoDiego9
Helper I
Helper I

How to store a permanent table in PowerBI

I'd like to store a table in PowerBI, with a list of all the holidays from year 2000 to 2100, for use with many PowerBI projects.

Since the table is permanent (doesn't change) I don't need it to be tied to a location external to my PowerBI Desktop app.

Is it possible to store it internally and cut/delete any link to its original external source

1 ACCEPTED SOLUTION
speedramps
Super User
Super User

Various options:-

 

1) Use the Enter Data option, and coy and paste the holidays in there.

 

2) Turn off refesh on that table, because it is static data.

 

3) Use data flows

 

4) It is best practice to have holidays files on server with other data, with a front end that can edit it.

In which case you just import is like any other table into PBI

 

 

I have helped you now please help me with kudos.
I am a Power BI volunteer so please click the thumbs up if you like me trying to help you.
And click Accept As Solution if I have fixed your problem.
One problem per ticket please. If you need to expand or change your problem then please accept this solution and raise a new ticket. Many thanks 😁

View solution in original post

1 REPLY 1
speedramps
Super User
Super User

Various options:-

 

1) Use the Enter Data option, and coy and paste the holidays in there.

 

2) Turn off refesh on that table, because it is static data.

 

3) Use data flows

 

4) It is best practice to have holidays files on server with other data, with a front end that can edit it.

In which case you just import is like any other table into PBI

 

 

I have helped you now please help me with kudos.
I am a Power BI volunteer so please click the thumbs up if you like me trying to help you.
And click Accept As Solution if I have fixed your problem.
One problem per ticket please. If you need to expand or change your problem then please accept this solution and raise a new ticket. Many thanks 😁

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors