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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
TobyLewis
New Member

Power BI (or possibly another source) creating new rows with text in my Queries, ruins formulae.

In some of my Queries I am cleaning data by removing blank rows amongst other things. However, every so often (feels like every new time I open my computer) I notice that Power BI, presumably, is inserting two rows into one of my Queries. One of which is a blank row and the other, above this blank row, is blank also except for two cells:

- "Check Point Threat Extraction Secured This Document", and

- "Get Original".

While mildly irritating, the true frustration lies where the insertion of these rows changes from query to query, removing it from the previous one while moving it to another one. 

This messes up my Remove Rows step in my queries as I must change how many rows I remove from the query. This of course means that when I sent or publish the document, it may not run if these rows have been inserted in a new query since the last time I fixed the problem.

PBI Forum ss1.pngPBI Forum ss4.pngPBI Forum ss3.pngPBI Forum ss2.png

PBI Forum ss5.png

Above are screenshots of the problem. Hopefully this is helpful.

 

Thank you very much for you time in advance 🙂

3 REPLIES 3
TobyLewis
New Member

Hi Pete

Thank you so much for taking your time to look at and help me with this here. Your idea did indeed seem to work and I no longer have problems with it.

 

Do you by any chance know why this message occurs in the first place? My colleagues and I are completely stumped on how, even after some extensive Googling (no problem if not, we're all just super curious).

Thank you again and take care 🙂

Toby 

 

I've no idea I'm afraid. I can only assume that your company uses the following software and it's adding these tags to writeable documents (XLXS, CSV etc.) within your document storage area (network, SharePoint etc.) once it has scanned them and marked them as safe.

 

https://blog.checkpoint.com/security/threat-extraction-a-preventive-method-for-document-based-malwar... 

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




BA_Pete
Super User
Super User

Hi @TobyLewis ,

 

I may be oversimplifying this but, as your [Column2] contains your data's ID column ([App ID]) which presumably never contains null values in the actual data body, couldn't you just remove redundant rows by filtering on [Column2] <> null, instead of trying to remove a specific number of Top Rows?

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors