Forum Discussion
Helper IIIStop Power Query from refreshing
Hi UBComma ,
Power BI isn't a data warehouse/data store, so there's no 'easy' way to do this - it's just not designed to be able to.
Whilst you could go through the process of hitting the 'Include...refresh' toggle, I think you'll find that this is ignored once you publish to the Service.
The only thing I can think of, depending on how large your PDF sources are, is to use the 'Enter Data' function in PQ to fix your sources as JSON binaries within the M code. You can paste 3,000 cells into one 'Enter Data' table or, if you can convert your files to CSVs, you can paste in 3,000 CSV rows.
Pete
For the benefit of future readers:
My current recommendation would be to import and transform any data that you wish to remain static into Dataflows in the PBI Service. Once done, you never need to refresh the Dataflow again, but this static source will remain available to all reports in future.
Pete
Super User
For the benefit of future readers:
My current recommendation would be to import and transform any data that you wish to remain static into Dataflows in the PBI Service. Once done, you never need to refresh the Dataflow again, but this static source will remain available to all reports in future.
Pete
