Forum Discussion
Public Web Report Data Security Through PowerQuery Transformation
MarkDuslak I would say that as long as you strip out all the PII you should be good. Something that you can consider is the pre-aggregate the data into tables using Power Query. I don't see any risk just having it refresh in the Service. The Service encrypts the credentials and it isn't exposed in any way publicly.
MarkDuslak You are going to use an Import mode semantic model, correct?
Greg_Deckler ,Yes. Import mode, not direct query or composite. I should've been more detailed in the original explanation. Our student information system is an Oracle database. That data is queried via SQL and tables are created. The tables are housed in an Azure blob and are imported to Powerbi.
MarkDuslak I would say that as long as you strip out all the PII you should be good. Something that you can consider is the pre-aggregate the data into tables using Power Query. I don't see any risk just having it refresh in the Service. The Service encrypts the credentials and it isn't exposed in any way publicly.
