Use VBA to Disable PQ Preview in Background

Power Query Data Setup
1

Hi

I want to ensure that users of my Excel Workbook have "Allow data previews to download in the background"disabled.

I intend to run VBA as part of the On open macro.

I also want the Privacy setting for the workbook to be set to Ignore Privacy settings.

How would one go about this with VBA.

Thank You

2

@AllisterB ,

I have no idea how to do this (I just use Excel as a pack mule these days to haul my data into Power BI), but am looping in @AntrikshSharma for awareness, who is not only is a DAX guru, but also a wiz with VBA…

  • Brian
3

@AllisterB I know how to interact with Tabs in Excel Ribbons using VBA but I am not sure if the same can be done with the Ribbon of Power Query.

4

Hi @AllisterB, a gentle follow up on @AntrikshSharma’s question above.
This will help you resolve your inquiry faster. Thanks!

5

Well if you and Brian Can’t do it - I’ll give up and find another way - Thanks