Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi!
I'm not sure I should post this here or in Power Apps Forum since it is related to both of them.
I'm trying to use Power BI to view PDF based on data selected in slicer
For Example ,
Branch Number
1
2
3
4
Basically, make visual show PDF of Branch's layout regarding to Branch Number in slicer that was selected.
My database is in Sharepoint Library / Onedrive folder that contain PDF files named according to the Branch Number.
I searched about my problem in this forum and found that I need to either use 3rd party visual or convert to base64.
However, I can also use Power apps and heard that it can be embedded in Power BI.
The question is can I use Power apps as pdf viewer for power BI without converting it to base64 ?
If it is possible, could you please help explain how to do it ? (such as data needed for Power BI to pass to Power Apps and coding in Power Apps to read it )
Thank you in advance.
Solved! Go to Solution.
You could use something like this technique in a canvas app, then embed that in your report.
https://www.matthewdevaney.com/power-apps-view-a-pdf-stored-in-a-sharepoint-document-library/
You'd use the Power App visual in Power BI to set this up-- I've not actually tried this combo, but it sounds plausible.
This visual can display PDF in the report/dashboard: https://www.youtube.com/watch?v=TEou0LuPjkA
You could use something like this technique in a canvas app, then embed that in your report.
https://www.matthewdevaney.com/power-apps-view-a-pdf-stored-in-a-sharepoint-document-library/
You'd use the Power App visual in Power BI to set this up-- I've not actually tried this combo, but it sounds plausible.
@christinepayton
Thanks ! this is working
However, the text in PDF still look blurry when at 0% zoom and need to zoom in the see clear text
It is not good as open directly from the website.
This happend only when viewing Power BI in web browser like chrome or edge.
Any Idea how to fix this? Thanks!
But everything is crystal clear in Iphone and Ipad.
Hmm I would try fiddling with the scaling options. In Power BI, in the View tab, Page view dropdown, I would try setting it to "actual size" for your report vs fitting to width/height, my guess is it's the scaling that's causing the blurriness... but it might also be happening just for the app visual embed if it's trying to scale that, I'm not sure. There's also a canvas app size scaling feature you could try turning off, though that one's usually off by default I think.
Hi @ViewP ,
Did you try to direct to a url when you click a button in power bi?
It does not show your pdf in the report but once you ckick the button after selecting the Branch Number, it will open pdf in your web browser.
Thanks.
Hi @Dinesh_Suranga
Thanks for replying.
I looked into it , But user prefer to view it in power BI as they need to view other visual in the same page at the same time.
Hi @ViewP ,
Did you try to show a web content in power bi?
Then you can try to load pdf to thet web content.
I used following video to learn to write back from PBI to Power Apps. You can use that to pass data from PBI to Power Apps.
https://youtu.be/uPHwjPRnRwE?si=0uQcxboDyfDNkhRv
Thanks
Do you mean by html web viewer in Power BI ?
I tried that but since the files are located in sharepoint , microsoft reject the html web viewer request.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
85 | |
65 | |
51 | |
45 |
User | Count |
---|---|
217 | |
88 | |
81 | |
65 | |
56 |