Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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.
Proud to be a Super User! | |
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.
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.
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.
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.
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.
Proud to be a Super User! | |
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.
User | Count |
---|---|
107 | |
88 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |