Forum Discussion
Export to file - Power BI Report with Filters / Parameters
HI All,
I am looking at the new (currently in preview) API for exporting Power BI reports as images/pdf files.
https://docs.microsoft.com/en-us/rest/api/power-bi/reports/exporttofileingroup
There currently isn't a way to specify Filter/Slicer values for Power BI Reports!
This feels like a big omission to me, especially considering the inclusion of Bookmark capabilities.
Is there a published roadmap for this API endpoint anywhere AND/OR does anyone know if we can expect to see filter options anytime soon?
The API is unusable for many scenarios without this.
I am keeping my fingers crossed that it arrives soon.
Cheers,
Matt
Hi Anonymous
The documentation currently states that the Bookmark name (whilst accepted as a parameter) is not currently available.
https://docs.microsoft.com/en-us/rest/api/power-bi/reports/exporttofile#pagebookmark
The only way to update output via bookmarks, is to pass in the bookmark state.
And the only way that you can get the bookmark state (that I know of) is via the JavaScript API. https://github.com/Microsoft/PowerBI-JavaScript/wiki/Bookmarks#capture-and-get-a-current-view-as-a-bookmark-object-and-apply-it-back-on-the-current-session
The 'capture' function will return a single string value that represents the bookmark state. You can then pass this into the API.
This is far from ideal... but I think the export API endpoint is still under preview, so will likely change quite a bit.
The idea I raised for adding missing functionality to this API has also moved into the planned phase. So hopefully, it won't be too long before these missing features are available. https://ideas.powerbi.com/ideas/idea/?ideaid=0e056f7d-34b4-4778-974f-929228effcdd
Cheers, Matt
25 Replies
Hi orygreg2, Anonymous,
Here's a solution. BI Helper bihelper.tech automates the generation of PDF / PPTX reports from Power BI (Pro and Premium), with slicers and filters applied either in batch mode or at runtime. Our implementation bypasses the limitations of the Power BI API endpoints.
In BI Helper, you can select pages to print, schedule and generate multi-page PDF / PPTX reports and email them to your users. Our users routinely run hundreds of reports of up to 30 pages each, with the process fully automated from report generation to delivery.
BI Helper is simple to configure and use with your Power BI reports and dashboards. It is secure and scalable and we offer a 14 day free trial. Test it out and let us know how it works.
Kiran Hosakote
BI Helper
I am struggling to find any details of 'future changes' or roadmap details for this API, so I created an idea for the inclusion of filter parameters.
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/40060261-add-filter-options-to-the-export-file-api
If you think that this functionality is missing - please go and upvote!
Thanks.I feel your pain Matt! I just spent 3 days writing code to use the API to export a report to PNG. I just got to the filtering bit - we need to create a separate image for each filter value - and have hit a brick wall. Did you find a workaround?
Hi latearrival
No workaround that I know of.
Depending on how many filters you have and what your model looks like, you might be able to use the Bookmarks feature?
I attempted to work out if we could generate bookmark state at runtime, then apply it to a PDF/PNG export, but this was a non-starter.
Looking at the idea site though... looks as though this has progressed to 'Under Review'.
So I guess we will have to wait.Hi Anonymous
Yeah, I see that bookmarks is a workaround, albeit a poor one. The whole point of using the Export endpoint is to automate. And creating bookmarks is a manual process.
I'm very very new to Power BI so I can't get my head around this yet, but this article hints at being able to fudge Roles (handing in a fake user ID as a query string parameter when the access token is requested?) and using a permissions table to drive Row Level Security. So, to use the Export endpoint to produce a sales report for, let's say, a given product, I'm wondering if I could hand in a product code as the fake user ID and then... (I'm not sure what happens then 🙂 ).
Hey,
Anonymous , did you solve your issue?
Workaround: Adding a dimension table to the row level security feature (the dimension you would like to filter on), and then filtering using the identities paramenter and then just looping on that should solve the issue. 🙂Hi Anonymous,
We have an independent solution to the PDF export problem. We've built a tool called BI Helper https://bihelper.tech/ to automate the generation of PDF / PPTX reports from Power BI (Pro and Premium), with slicers and filters applied. Our implementation bypasses the limitations of the API endpoints.
With BI Helper, you can select report pages to print, schedule and generate multi-page PDF / PPTX reports and email them to your users. BI Helper has an option to include matrix and table visuals as Excel files, and lots of other advanced features. Our users routinely run hundreds of reports of up to 30 pages each, with the process fully automated from report generation to delivery.
BI Helper is simple to configure and use with your Power BI reports and dashboards. It is secure and scalable and offers a 14 day free trial. Try it out and let us know how it works for you.Kiran Hosakote
BI Helper
Hi,
I'm trying below mentioned request for export but API is throwing error, I appreciate if somebody help me, i need to solve this ASAP.
API Endpoint:
https://api.powerbi.com/v1.0/myorg/reports/{reportid}/ExportTo
Request:
{"format": "PDF","powerBIReportConfiguration": {"settings": {"locale": "en-US","excludeHiddenPages": "false"},"defaultBookmark": "H4sIAAAAAAAAA+1deW8bR5b/KgSB3cwASlD3kf9kyd4Em2S8VpLdwSAIXlW9knpCsjnNpmxN4O++1QclSuLRJimKlokkCNVdXf2u+r2jjv6zH7LJeAA3P8EQ+9/2X+X5H0Mo/ujR/kl/dP+a4SQSTkOgjnmtSVCUpFb5uMzy0aT/7Z/9EopLLH/NJlMYVB2mi//47aQPg8FbuKz+ijCY4El/jMUkH8Eg+zc2jWe3Pp708cN4kBdQ9XlRQolVv9epffo70UK/4emV4MvsGi/Ql83VdzjOi3L290k/ZoMyPVI96m5efxgXiY4/Z+y8qW9KxRwlzGhLNJFMUaZNerK8GVdtztKLL/Mi8zDo1yQVOGko+LN/lg+mw/rX63vXL/Jp4fEdxvrWqMzKm9TTLxMsTicTLE+9T237HxOLb4s8SeD29ushZIP6xlX+/qzA9O7Q/5Z+PHlEsoyRgdCCAAplrCXPQXJ96/uwgODf0pVJo4Ra9vfVUumxVvZZPiohG7UKshQ8kcoIYgGgMqxAq+uLddgyexquYeTTWx9y+iPCZFpgV1avT32ZKDrPJm5aTHCIo/IRu3WL3nyT3ukwn7Yt5yVAGglko8tBa9d3TP/cEO6hqIjO3T+TVCrm0gN5EbB4dVPzd54VM3Gxkwcs7Jm3xEw1HFEAM0ZJHpTySksn+N7Uc5F6qYSBYV7kcwxUDbIye9DgcHWyEUONIhSLNg0SargAJYUiKMjmiji9vCzwEmYD8/UWcHH9JhtVVMOgRoZHePEGfDZITWtpV/feTEetOPlOtFV1AlQiJ84LHjiVzCircN8o8rbIkhjGMEi4BzeLxlvbYoC9v03LSQmjkDg9cJPdmrmZ+QaHKGXCDx8FFY6rsG8FfT9Kr8JJ+XYxA7PbvZbBXpjiAuWcPLv9VJA9xS0QbzgdlNm79MzhmtFDHhsrMmi8tS5gTOGCo1wx6ZZb0b3oyYBUwqNFglx7iMkc5bLoqemu6u3XWeSZ+H9T5MO63zZWvk4tl6PgSb8RdlLHSf9/r7AS1T8qbE3jYga7P+XlY/l9/wB5J+1zHTC5+aMmbVHQVtP9saLnVxhM6+g89fxDlnhtjKS+nFqPpoMqIP0tybyW/Hbx5DoHMU/bJ5vyZJD5pKp5I+4PMaUh1Y9LHDWsJTbHzQsznNwZzP1fT6vrA1DrVwGHeY9QSr6aabfWcHoyQAkLxDTMQy1IrIfU4k7P0xMhfz+q+mw6m+BgBhuPepyUaZCVF7VKL+p2a/qv88K269rT17lfksE/5zKNW8af0jZ/qyONSCQxTFjH0QcOQkRa5ysrrbTED6XLPzyOWxiGED2NnjNCQXgZlTqk7OftAEZVMHo2LYrKJb75+z49Yofc5fAI+xWKrHpXV9J2l7ifweSq92aQv+/9DG6Aj3TZhjW3gfgBCKuyr16ZDZK3r2o9B0LVrQp/PjTKWqtfRddal1lWxvH6Q8fAjz59GWLxiGnrDw6BeWYtaFNlEMSB2hxuUVBNWPDIPBKmkZqmmrFZbyQFk55rQ4IL4K3zKQPdvDejjdeOcOAcmPE+OMY6xraCePQuCBcVKpLYkiFsF9uG+XinNrRnjWfDQ5NpbX/foeztkHtMyoLq7Tp42P7df0coJnvyLove/2M+Kq9WE7AzcGxDkS7RSrdi7XMC+HNR+Hvb/lGgOxOd6jU6/Ut74a8HRlYjv0VUrfV7g2yEZ4PppKryhMb2z/Khy8+uoCg39Ya7G8OVWJ/2TbejtcLNhXlUixY3G2RSK+Fpp9Q3eRh6IF5IXs1LGI6EC8AtXLlnKmqtrGKCWm8DWTXNcc/5Mh45KnBAlaVIhXJqy8LS0fnuwflu6H46FDBbyLorZN423Qrpj9HCLhzK2TRxARX0zSloprKkntFzO+KFBLZRwx7p61yvb0mbo3W4cE7iJAFoA2IPARR0AMtBp+SOGKYIIoM7AH39wQ+mAV8MeH6qT1ze051DXAvEjDD6Q/PSRSXc0+nlV/dxel55Yib6Oyp/xBKakvGfc2a2SQF2j2HDSd+Dv8JQs/19icOG3ixg9XzW1o8nPj36fT03eTqq//cDxrIBwOEYimwyg8PZX/+dVe3IyVzD3SH1u+zyqu50hVbvtdsjlXN4vorMmXnNpgeuq+s/wrhqQ1o20iClFZhML5sA7xjMf1HBvAUQhDGgNCgiUxCe4uiO4bfiGimmDCAIQlikMSg8ht8vNfxes4RjFsilZqkV3i7lOEbczxfQpgAxRYXZbHFNgct1sn7d0wPEP4L9Zwj2AYw0gQg0AYB7qzXqrmBPbBTo0PIojEZJItnpIp4L9NMi/T5P8W02eMaFHXeETHyR1Svsuy3xeP2vaVZP8PV+zIsSLrH3PiuvepO2v57Pr7Ho5bFHv5F1zH+ypKOYFWm0+qtqSX8vH/XOL96drnzgzYMHYvYhITFUCyg+6UXjAYbqV+xx8h8rnxzn7xteoCzzYoQ3K1u/bTcd9P5rCgUkOMJJLyZr6H04uTn5d6/ZkzCZWxmz5aqnh7bUScP7cBRrKSuhnC5yGk89s/xEbDQTydyh8kwGaq3XSmOkwVf9bVYvtowaKwJSZ6JXRCgl/HIMO6433vt6Y2eEsR6ktxi5lxqN2OO2kreYgKa8aaPUR6b5c16FRG2jQ9fHJ/LSjjbkjnAunGBcsYA+kBXiv+fjNQTvPA3SCQXBCIUEtvPxg3kf/0OeHq2ilHqN1O8kWEI5uq+Vk+JrwZT7Giwz6ZfAqizJBWXPm/8NFoZTB50Azipt53d7C2e1thpy70psT1St2kTJS6S8urbVSriJa+/tpPzLq5SL/vHXfiX2/e7HWTNg29tzU1F3G3LIAaaqa8Fw4lP8h8XCZHBhrvR/O0qSHuQ1mhgwHDTlCcAMccrFPa7lXaP1n/IqUH4ZLuchL+3eEK6lBy0keO6Ndh7FirRy91H1ZQpDkzwTuBWPLOU03Viyw2GflZjry97fYu9dNvmj9y5hzeiyVxG2iTWMs+u8bFYZ72cZ6QZMLa2VvMvfb7RXoKOG2/UpqIinXEkDKZThJCqzYsPbvQgoUJ38Z2DeBVDJZaUO+F0E9A4H9fRwW5l+ypr2KyzfI27qkdZWsJN3rzL4V8kR1aKpLl+MYUG/P+Xv68wrEZ0N8ZdRVra+6pfxuFMH1Z3TED7hxt0rW0/57df00etnt9T8HfaIzmP1fX/rQ59ogc5aRHyOPZW7Zblxo9EGR6mQDg1QLhkBZTrilvRMa5CKoALhNbVGsl1WZ+/h7/PtuZtD+vX12Nb19M7xGgf5uJb4f/aqIzCKaW0GtefaXdVxoyjkKTBjH1HIHmPSjeKPqqmiXnOdMgLpBY3C0iC3qDtSwoOyRkkLNBLUWruuG6A1MGup8UEJbhz41JV7iuNjKhNMWXx6dUXRIjt8O7t7cXv32ayxySW+Syl+o8Jb2j5Xe1zFUFubA8K1oEKhY8J7AZatWGyxazedxgjmcRZJfJdNymrW8gETVaOKjVmzb77ZLIb4LkuAXPirmx8q+H1M4+39x7dm1NSb0+rTqFqPsDWfrW+77bh//7iU5AJvA7s5+upor3d3oQ6fG67q2dpN7LVeRLXNHPqXJd9uk+9flkyaZJcxHwyhXhnuFA0x/QebOznmY+WkVPQWOXqORofNe+Mx9RSVqvZUCmWJEbhiqu6ey/TCp4fBKZE8p7XEGbB3LnMvxdxNnOldPZcu9K33eeQcqfDKau6dldoax585LFiM9feoxkhscmHc6eTEuCI6UPrMVL/D6pDEDrQrKohmJhIPKZBjmiPBDla1sy11FcG9xaHXwe0e78hFm7oyo32wDgJlQlAanTbboFDgjlNhjRComYuOyLVh0g4Pc6jmwkY3vfMFnJeZnw4Wuvw9Rs7zyy6e1IaeLFS+46CxH+ZQCpQoKKCU3DIZViRXz7bh5jq540vsneMAknnAzUYqOMQVHQs5a1RjQUobJTcMrNIgo+fbhARBaqICEGEssZSmZHrvZ46uF0eTyTXCeLvFmtkD1PRi1toDnoKJSlNhGOExeOE461qAFDpp07gUMmrvjdNBuuM5GMe9AC9vNuK4eWFvQU6CqI1LK8f9aZ2rJoe9ZUG5YDXhxhPqrQshAl1/ChXUrL6almVdb3kQgwiCEFBqJVTwNETeHve0RZeRehQhhUq+WgqjjOVUb9kli4oZFUNyqUwYqqNTWxR2AtGoOBpWLc5FBDC+6+xFtDwqwRBVSp9DSMEgt9u59s9/bvH27MqDmUO8X1mKlEUJTgtnlEKMwsduNZrnK6EmjIZxyrp9Qu2s7BX1hN6kQwl1JyX7A52HfZJNKKuMLCwKJTv5/R2XXlcOg04F133Mwuxe8k/hs7u8t/G2InKqBEbkLvkb6QXSrocxUUMYaBKZROIMocTIpdXsDd1EtYMu4W5Zfdsk5oMsnzQbjZ7Nafh8OB5Ayh7wdstTB+dxWqt3p05jmWTW07vOlUSptPExRQ0awXOnfIpsXrhaoQHjT4kDnkObsMhnPEna352ms7bZoZfLNuKorZJpiBwC1YxZASmDALtiduKIkRthZDUHM8gSH58JTHrLUSig0mIMpDqXGHa6Pf4QNXuEySNMLodJ5T1VmilGHAXFMFAejzC5Y5j8KR/1PjeoVJRqqZ0XTIYI3Culdr1W/eC0e4TKI1Quh0qplOaCM27SP1SFoNgx6949VJa9i6kbZmWyns8EKsF57UwE6mNSrwtW8i1n1Q9fu0eoPELlcqi0gTjpKU9plooJ7ajV23wDjDJjZTQohUITlNGh607hI/B2Bd7XH3A4/nwwN4CIjnrJq/OlGE1+GY/h6RFzv2DMTUCrHaoYCAUewVNrtsDcQEFX8wlKsxTqehG07Hrg8BFzX3JdIHpK0WkWpPdaOi3ZzvewH5x2uwPv7MjFI+5+MbjL0WsBLjhQTGD6odAekfKLnozXzmC03CjCGTISvFYvXa1HiDxC5FKIdGhdStGcQ0qENQ6hWXB4hMgveC4+GGWZkiowa5kjhhGy5XdJDl+zR5Q8ouRSlNRghdJgqrPBpLUpgZddz2E4ouRLnl/yjGnJRQzUojcyKGbFS9fuESmPSLm81KlpdVKNCsorlkaEA77iIOl7Y8kRQEsZgiIscp56kce52sVjafl3bA5ycuH+WX6RMIdGMArSEJFcqSYvXc0vdd7vCKVPuUyeKSGMiAoZQ26E4Gb9ltils0Yq5XTKUxoESuUsRWX45r2hAyKUt9qADwYgYf36HcCTKxjj475E/bkbBQAykuCZ1bh+g/KyviIqJBStC5w6y6UicdO+aFBgAVEE1A6CEDKul9iSvriAxFv6lxGjkzKRK7JpX+hESkds1ChIta7Jm2b7xIbnyUirkpsmXodkFiBA0C0OnoomeMeDcNbwxGxAabfYcy21cyYA91xRGjEYg+u1uZw20Mkkkl0YAegMUypucQ5PCm+Ed1JIHaPj4K3jW4wnqpMfFEhNIOhQGCPFevtY2hvRTJOqwO0k8YbxaJud713OwUYVMI1Gb7xB54nzYvEBb5u45tvw5LT6st7FdDiE4ub36rj5ah9pJ/e88Hia3X6JZ7kbbzxzdbHbd3V24LHXiGwpgXvYBf1ppG11OHHZdvrq5n+mWNzkI3Z+bk/ToDmjZ6/EKyrM6Sk/P2f87PUb+Yq9sXvajryZdlr3zpklNATkiAjUEWW2ADetouAJ2rykKE1yzNJuc8hYclcymkhjAgKWYDi5iI4AInhy5ZJXrtc4nzxxhKVHdb+Mc6xmh7esj+if/iCrZecerR1hk0HmkyrmLaE/xOKyjnQDlFBLaty8KcPmfh7q21gbwuIc5jw9EfL3o6/6Lc8fl+zOvxXdLsXQ7MlPsTOVVnovhJJINATatSYhg6IkOcQQUWoduKxirRdtzXenBx2AOW/xYbUXZc8PjnQiKUdS1QlJGpBywZgy67Ov5dGioMxEkxxQCt1BoUWzRezplOeCesp9ICkVk9S7rl/INiCV8On9BLn2EIPDnW4Bvu+tu5WDnmzgPT4/qSKq8wFKux17j0SzgrblZaAniy0f10oGGY4WE7QtNlziqJH1I3i4M7l9Gd+T2Nk92XWoQp7jMO81D80VIptzdnYIpElnOJjF5Y96nJTJrMqLWqsXdbs1/UcYTPDJMPqT7LPBbIpRg3BGSycTyPmUvOzvyyXHDxo1Jvtx8ZjPp+VkDB7fwggXGF8SPYwChjUmVxbTO4v7+PH/AUUCsz6fsAAA"}}Response:{"error": {"code": "BadRequest","message": "Bad Request","details": [{"message": "Error converting value \"H4sIAAAAAAAAA+1deW8bR5b/KgSB3cwASlD3kf9kyd4Em2S8VpLdwSAIXlW9knpCsjnNpmxN4O++1QclSuLRJimKlokkCNVdXf2u+r2jjv6zH7LJeAA3P8EQ+9/2X+X5H0Mo/ujR/kl/dP+a4SQSTkOgjnmtSVCUpFb5uMzy0aT/7Z/9EopLLH/NJlMYVB2mi//47aQPg8FbuKz+ijCY4El/jMUkH8Eg+zc2jWe3Pp708cN4kBdQ9XlRQolVv9epffo70UK/4emV4MvsGi/Ql83VdzjOi3L290k/ZoMyPVI96m5efxgXiY4/Z+y8qW9KxRwlzGhLNJFMUaZNerK8GVdtztKLL/Mi8zDo1yQVOGko+LN/lg+mw/rX63vXL/Jp4fEdxvrWqMzKm9TTLxMsTicTLE+9T237HxOLb4s8SeD29ushZIP6xlX+/qzA9O7Q/5Z+PHlEsoyRgdCCAAplrCXPQXJ96/uwgODf0pVJo4Ra9vfVUumxVvZZPiohG7UKshQ8kcoIYgGgMqxAq+uLddgyexquYeTTWx9y+iPCZFpgV1avT32ZKDrPJm5aTHCIo/IRu3WL3nyT3ukwn7Yt5yVAGglko8tBa9d3TP/cEO6hqIjO3T+TVCrm0gN5EbB4dVPzd54VM3Gxkwcs7Jm3xEw1HFEAM0ZJHpTySksn+N7Uc5F6qYSBYV7kcwxUDbIye9DgcHWyEUONIhSLNg0SargAJYUiKMjmiji9vCzwEmYD8/UWcHH9JhtVVMOgRoZHePEGfDZITWtpV/feTEetOPlOtFV1AlQiJ84LHjiVzCircN8o8rbIkhjGMEi4BzeLxlvbYoC9v03LSQmjkDg9cJPdmrmZ+QaHKGXCDx8FFY6rsG8FfT9Kr8JJ+XYxA7PbvZbBXpjiAuWcPLv9VJA9xS0QbzgdlNm79MzhmtFDHhsrMmi8tS5gTOGCo1wx6ZZb0b3oyYBUwqNFglx7iMkc5bLoqemu6u3XWeSZ+H9T5MO63zZWvk4tl6PgSb8RdlLHSf9/r7AS1T8qbE3jYga7P+XlY/l9/wB5J+1zHTC5+aMmbVHQVtP9saLnVxhM6+g89fxDlnhtjKS+nFqPpoMqIP0tybyW/Hbx5DoHMU/bJ5vyZJD5pKp5I+4PMaUh1Y9LHDWsJTbHzQsznNwZzP1fT6vrA1DrVwGHeY9QSr6aabfWcHoyQAkLxDTMQy1IrIfU4k7P0xMhfz+q+mw6m+BgBhuPepyUaZCVF7VKL+p2a/qv88K269rT17lfksE/5zKNW8af0jZ/qyONSCQxTFjH0QcOQkRa5ysrrbTED6XLPzyOWxiGED2NnjNCQXgZlTqk7OftAEZVMHo2LYrKJb75+z49Yofc5fAI+xWKrHpXV9J2l7ifweSq92aQv+/9DG6Aj3TZhjW3gfgBCKuyr16ZDZK3r2o9B0LVrQp/PjTKWqtfRddal1lWxvH6Q8fAjz59GWLxiGnrDw6BeWYtaFNlEMSB2hxuUVBNWPDIPBKmkZqmmrFZbyQFk55rQ4IL4K3zKQPdvDejjdeOcOAcmPE+OMY6xraCePQuCBcVKpLYkiFsF9uG+XinNrRnjWfDQ5NpbX/foeztkHtMyoLq7Tp42P7df0coJnvyLove/2M+Kq9WE7AzcGxDkS7RSrdi7XMC+HNR+Hvb/lGgOxOd6jU6/Ut74a8HRlYjv0VUrfV7g2yEZ4PppKryhMb2z/Khy8+uoCg39Ya7G8OVWJ/2TbejtcLNhXlUixY3G2RSK+Fpp9Q3eRh6IF5IXs1LGI6EC8AtXLlnKmqtrGKCWm8DWTXNcc/5Mh45KnBAlaVIhXJqy8LS0fnuwflu6H46FDBbyLorZN423Qrpj9HCLhzK2TRxARX0zSloprKkntFzO+KFBLZRwx7p61yvb0mbo3W4cE7iJAFoA2IPARR0AMtBp+SOGKYIIoM7AH39wQ+mAV8MeH6qT1ze051DXAvEjDD6Q/PSRSXc0+nlV/dxel55Yib6Oyp/xBKakvGfc2a2SQF2j2HDSd+Dv8JQs/19icOG3ixg9XzW1o8nPj36fT03eTqq//cDxrIBwOEYimwyg8PZX/+dVe3IyVzD3SH1u+zyqu50hVbvtdsjlXN4vorMmXnNpgeuq+s/wrhqQ1o20iClFZhML5sA7xjMf1HBvAUQhDGgNCgiUxCe4uiO4bfiGimmDCAIQlikMSg8ht8vNfxes4RjFsilZqkV3i7lOEbczxfQpgAxRYXZbHFNgct1sn7d0wPEP4L9Zwj2AYw0gQg0AYB7qzXqrmBPbBTo0PIojEZJItnpIp4L9NMi/T5P8W02eMaFHXeETHyR1Svsuy3xeP2vaVZP8PV+zIsSLrH3PiuvepO2v57Pr7Ho5bFHv5F1zH+ypKOYFWm0+qtqSX8vH/XOL96drnzgzYMHYvYhITFUCyg+6UXjAYbqV+xx8h8rnxzn7xteoCzzYoQ3K1u/bTcd9P5rCgUkOMJJLyZr6H04uTn5d6/ZkzCZWxmz5aqnh7bUScP7cBRrKSuhnC5yGk89s/xEbDQTydyh8kwGaq3XSmOkwVf9bVYvtowaKwJSZ6JXRCgl/HIMO6433vt6Y2eEsR6ktxi5lxqN2OO2kreYgKa8aaPUR6b5c16FRG2jQ9fHJ/LSjjbkjnAunGBcsYA+kBXiv+fjNQTvPA3SCQXBCIUEtvPxg3kf/0OeHq2ilHqN1O8kWEI5uq+Vk+JrwZT7Giwz6ZfAqizJBWXPm/8NFoZTB50Azipt53d7C2e1thpy70psT1St2kTJS6S8urbVSriJa+/tpPzLq5SL/vHXfiX2/e7HWTNg29tzU1F3G3LIAaaqa8Fw4lP8h8XCZHBhrvR/O0qSHuQ1mhgwHDTlCcAMccrFPa7lXaP1n/IqUH4ZLuchL+3eEK6lBy0keO6Ndh7FirRy91H1ZQpDkzwTuBWPLOU03Viyw2GflZjry97fYu9dNvmj9y5hzeiyVxG2iTWMs+u8bFYZ72cZ6QZMLa2VvMvfb7RXoKOG2/UpqIinXEkDKZThJCqzYsPbvQgoUJ38Z2DeBVDJZaUO+F0E9A4H9fRwW5l+ypr2KyzfI27qkdZWsJN3rzL4V8kR1aKpLl+MYUG/P+Xv68wrEZ0N8ZdRVra+6pfxuFMH1Z3TED7hxt0rW0/57df00etnt9T8HfaIzmP1fX/rQ59ogc5aRHyOPZW7Zblxo9EGR6mQDg1QLhkBZTrilvRMa5CKoALhNbVGsl1WZ+/h7/PtuZtD+vX12Nb19M7xGgf5uJb4f/aqIzCKaW0GtefaXdVxoyjkKTBjH1HIHmPSjeKPqqmiXnOdMgLpBY3C0iC3qDtSwoOyRkkLNBLUWruuG6A1MGup8UEJbhz41JV7iuNjKhNMWXx6dUXRIjt8O7t7cXv32ayxySW+Syl+o8Jb2j5Xe1zFUFubA8K1oEKhY8J7AZatWGyxazedxgjmcRZJfJdNymrW8gETVaOKjVmzb77ZLIb4LkuAXPirmx8q+H1M4+39x7dm1NSb0+rTqFqPsDWfrW+77bh//7iU5AJvA7s5+upor3d3oQ6fG67q2dpN7LVeRLXNHPqXJd9uk+9flkyaZJcxHwyhXhnuFA0x/QebOznmY+WkVPQWOXqORofNe+Mx9RSVqvZUCmWJEbhiqu6ey/TCp4fBKZE8p7XEGbB3LnMvxdxNnOldPZcu9K33eeQcqfDKau6dldoax585LFiM9feoxkhscmHc6eTEuCI6UPrMVL/D6pDEDrQrKohmJhIPKZBjmiPBDla1sy11FcG9xaHXwe0e78hFm7oyo32wDgJlQlAanTbboFDgjlNhjRComYuOyLVh0g4Pc6jmwkY3vfMFnJeZnw4Wuvw9Rs7zyy6e1IaeLFS+46CxH+ZQCpQoKKCU3DIZViRXz7bh5jq540vsneMAknnAzUYqOMQVHQs5a1RjQUobJTcMrNIgo+fbhARBaqICEGEssZSmZHrvZ46uF0eTyTXCeLvFmtkD1PRi1toDnoKJSlNhGOExeOE461qAFDpp07gUMmrvjdNBuuM5GMe9AC9vNuK4eWFvQU6CqI1LK8f9aZ2rJoe9ZUG5YDXhxhPqrQshAl1/ChXUrL6almVdb3kQgwiCEFBqJVTwNETeHve0RZeRehQhhUq+WgqjjOVUb9kli4oZFUNyqUwYqqNTWxR2AtGoOBpWLc5FBDC+6+xFtDwqwRBVSp9DSMEgt9u59s9/bvH27MqDmUO8X1mKlEUJTgtnlEKMwsduNZrnK6EmjIZxyrp9Qu2s7BX1hN6kQwl1JyX7A52HfZJNKKuMLCwKJTv5/R2XXlcOg04F133Mwuxe8k/hs7u8t/G2InKqBEbkLvkb6QXSrocxUUMYaBKZROIMocTIpdXsDd1EtYMu4W5Zfdsk5oMsnzQbjZ7Nafh8OB5Ayh7wdstTB+dxWqt3p05jmWTW07vOlUSptPExRQ0awXOnfIpsXrhaoQHjT4kDnkObsMhnPEna352ms7bZoZfLNuKorZJpiBwC1YxZASmDALtiduKIkRthZDUHM8gSH58JTHrLUSig0mIMpDqXGHa6Pf4QNXuEySNMLodJ5T1VmilGHAXFMFAejzC5Y5j8KR/1PjeoVJRqqZ0XTIYI3Culdr1W/eC0e4TKI1Quh0qplOaCM27SP1SFoNgx6949VJa9i6kbZmWyns8EKsF57UwE6mNSrwtW8i1n1Q9fu0eoPELlcqi0gTjpKU9plooJ7ajV23wDjDJjZTQohUITlNGh607hI/B2Bd7XH3A4/nwwN4CIjnrJq/OlGE1+GY/h6RFzv2DMTUCrHaoYCAUewVNrtsDcQEFX8wlKsxTqehG07Hrg8BFzX3JdIHpK0WkWpPdaOi3ZzvewH5x2uwPv7MjFI+5+MbjL0WsBLjhQTGD6odAekfKLnozXzmC03CjCGTISvFYvXa1HiDxC5FKIdGhdStGcQ0qENQ6hWXB4hMgveC4+GGWZkiowa5kjhhGy5XdJDl+zR5Q8ouRSlNRghdJgqrPBpLUpgZddz2E4ouRLnl/yjGnJRQzUojcyKGbFS9fuESmPSLm81KlpdVKNCsorlkaEA77iIOl7Y8kRQEsZgiIscp56kce52sVjafl3bA5ycuH+WX6RMIdGMArSEJFcqSYvXc0vdd7vCKVPuUyeKSGMiAoZQ26E4Gb9ltils0Yq5XTKUxoESuUsRWX45r2hAyKUt9qADwYgYf36HcCTKxjj475E/bkbBQAykuCZ1bh+g/KyviIqJBStC5w6y6UicdO+aFBgAVEE1A6CEDKul9iSvriAxFv6lxGjkzKRK7JpX+hESkds1ChIta7Jm2b7xIbnyUirkpsmXodkFiBA0C0OnoomeMeDcNbwxGxAabfYcy21cyYA91xRGjEYg+u1uZw20Mkkkl0YAegMUypucQ5PCm+Ed1JIHaPj4K3jW4wnqpMfFEhNIOhQGCPFevtY2hvRTJOqwO0k8YbxaJud713OwUYVMI1Gb7xB54nzYvEBb5u45tvw5LT6st7FdDiE4ub36rj5ah9pJ/e88Hia3X6JZ7kbbzxzdbHbd3V24LHXiGwpgXvYBf1ppG11OHHZdvrq5n+mWNzkI3Z+bk/ToDmjZ6/EKyrM6Sk/P2f87PUb+Yq9sXvajryZdlr3zpklNATkiAjUEWW2ADetouAJ2rykKE1yzNJuc8hYclcymkhjAgKWYDi5iI4AInhy5ZJXrtc4nzxxhKVHdb+Mc6xmh7esj+if/iCrZecerR1hk0HmkyrmLaE/xOKyjnQDlFBLaty8KcPmfh7q21gbwuIc5jw9EfL3o6/6Lc8fl+zOvxXdLsXQ7MlPsTOVVnovhJJINATatSYhg6IkOcQQUWoduKxirRdtzXenBx2AOW/xYbUXZc8PjnQiKUdS1QlJGpBywZgy67Ov5dGioMxEkxxQCt1BoUWzRezplOeCesp9ICkVk9S7rl/INiCV8On9BLn2EIPDnW4Bvu+tu5WDnmzgPT4/qSKq8wFKux17j0SzgrblZaAniy0f10oGGY4WE7QtNlziqJH1I3i4M7l9Gd+T2Nk92XWoQp7jMO81D80VIptzdnYIpElnOJjF5Y96nJTJrMqLWqsXdbs1/UcYTPDJMPqT7LPBbIpRg3BGSycTyPmUvOzvyyXHDxo1Jvtx8ZjPp+VkDB7fwggXGF8SPYwChjUmVxbTO4v7+PH/AUUCsz6fsAAA\" to type 'Microsoft.PowerBI.ServiceContracts.Api.V1.PageBookmark'. Path 'powerBIReportConfiguration.defaultBookmark', line 8, position 6257.","target": "request.powerBIReportConfiguration.defaultBookmark"}]}}Hi,
Bookmark is an object with name/state. Since you are using bookmark state I believe you should try something like this:
Request:
{"format": "PDF","powerBIReportConfiguration": {"settings": {"locale": "en-US","excludeHiddenPages": "false"},"defaultBookmark": {"state": "H4sIAAAAAAA..."}}Thanks,AmosThanks for qucik reply, that workaround worked for me
