Forum Discussion
DirectQuery: Decode text from Base64
direct query mode relies on querying the data source in realtime, and transformations like Base64 decoding happen within Power bi's internal engine, you can preprocess the data in etl to to decode then import it in powerbi. or you can go for source level decoding ie decode at database level
I think AnalyticPulse is right. Decoding isn't likely compatible with DirectQuery since it breaks query folding. The best option would be to decode it in the database before connecting.
Alternatively, it's likely possible to decode using DAX but you'd have to write your own custom logic to do that.
Hi Anonymous
Thanks for the solution AlexisOlson and AnalyticPulse provided, and i want to offer some more information for you to refer to.
Based on the picture you have offered, do you want use the base 64 to display picture? If you want to implement, you can change the base 64 to image url in data category in Power BI Desktop, you can refer to the following picture.
And you can refer to the following article about more.
Embedding Images in Power BI using Base64 – Some Random Thoughts (sqljason.com)
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
No, this is not a picture. It is a marc record that was encoded to base-64, and should be decoded for the user to properly view it. Thank you.