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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
b4_1909
New Member

WIll I Lose my Universal Analytics Data Post July 1st?

Hi All,
I have been experimenting with extracting data from Google Analytics predominatley GA4. However I have data that is present on a UA property and I do have the availability to connect to this as a source. I was wondering if I had a file pulling from a UA data source, when all UA data is deleted will I lose this data as a source in Power Bi?

Thanks in advance

 

2 ACCEPTED SOLUTIONS
Idrissshatila
Super User
Super User

Hello @b4_1909 ,

 

If I understand you right, if you're using import mode in power bi and you imported data from excel, if the excel sheet was deleted, you Won't lose the data in Power BI because it's imported in the software but you can't refresh it.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




View solution in original post

v-zhengdxu-msft
Community Support
Community Support

Hi @b4_1909 

 

Just as @Idrissshatila said that you won't lose the data.
If you import the data from the data source, these data will be stored in the data model of the semantic model.

vzhengdxumsft_0-1713838896245.png

So if you don't refresh the report after deleting all the data of the source, the Universal Analytics Data shouldn't be disappear.
Here for your reference:

Get data from files for Power BI - Power BI | Microsoft Learn

 

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-zhengdxu-msft
Community Support
Community Support

Hi @b4_1909 

 

Just as @Idrissshatila said that you won't lose the data.
If you import the data from the data source, these data will be stored in the data model of the semantic model.

vzhengdxumsft_0-1713838896245.png

So if you don't refresh the report after deleting all the data of the source, the Universal Analytics Data shouldn't be disappear.
Here for your reference:

Get data from files for Power BI - Power BI | Microsoft Learn

 

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Idrissshatila
Super User
Super User

Hello @b4_1909 ,

 

If I understand you right, if you're using import mode in power bi and you imported data from excel, if the excel sheet was deleted, you Won't lose the data in Power BI because it's imported in the software but you can't refresh it.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Syndicate_Admin
Administrator
Administrator

The answer to your question is yes. Because every time you import new data into Excel, you'll also need to update your Power BI file. Now, when old data is deleted from the Excel source and when the Power BI file is updated, the old Power BI data will also be deleted.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

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.