Solved: power BI import data life

sundayDriver · ‎12-20-2018

Hi,

I have a power BI report that is using import to get data from a SQL database.

Because of space limitations we're thinking of deleting the table in SQL. I was wondering will this delete the already imported data in power BI?

Greg_Deckler · ‎12-20-2018

No, not if it is imported but you'd better make sure to right-click the query in Query Editor and uncheck "Include in report refresh" so that you don't accidentally refresh and wipe out all of your info.

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

Greg_Deckler · ‎12-20-2018

No, not if it is imported but you'd better make sure to right-click the query in Query Editor and uncheck "Include in report refresh" so that you don't accidentally refresh and wipe out all of your info.

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

power BI import data life

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024