Add the Power BI connector from the data section.<\/p>\n\n\n\n
![\"\"](\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-201.png?resize=533%2C532&ssl=1\")
Workspace is a container in which all the charts will be created and charts should be pinned to a dashboard as a tile.<\/p>\n\n\n\n
Add the Power BI tile, Select the workspace it will display the list of dashboards inside the workspace and based on the selected dashboard, tiles will be displayed.<\/p>\n\n\n\n
![\"\"](\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-202.png?resize=640%2C266&ssl=1\")
<\/figure><\/li>![\"\"](\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-203-1024x388.png?resize=640%2C243&ssl=1\")
<\/figure><\/li><\/ul><\/a><\/a><\/a><\/div><\/div><\/div>\n\n\n\nOnce the tile is selected a URL will be generated, we have to pass query string parameters to load charts dynamically. A generated tile URL will look like the below one.<\/p>\n\n\n\n
Generated URL:<\/p>\n\n\n\n
\/\/Generated URL\nhttps://app.powerbi.com\/embed?dashboardId=a7xxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxa69&tileId=91xxxxxx-xxxx-xxxx-xxxx-xxxxxxxxx373&config=eyxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxfQ%3d%3d\n\n\/\/URL Split up\nhttps:\/\/app.powerbi.com\/embed?dashboardId=dashboardID&tileId=tileID&config=configString<\/code><\/pre>\n\n\n\nWith Query String:<\/p>\n\n\n\n
\/\/Filtered query\n\"https:\/\/app.powerbi.com\/embed?dashboardId=a7xxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxa69&tileId=91xxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxx73&config=eyxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxfQ%3d%3d&filter=TableName%2FColumnName%20eq%20%27\"& DynamicValue & \"%27\"\n\n\/\/URL Split up\nhttps:\/\/app.powerbi.com\/embed?dashboardId=dashboardID&tileId=tileID&config=configString&filter=Store\/Territory eq 'NC'<\/code><\/pre>\n\n\n\nAs you see in the above example, in URL split up the filter query is clearly shown and while passing into the URL it should be encoded.<\/p>\n\n\n\n
?filter=Store(Table Name)\/Territory(Column Name) eq (operator) ‘NC’ (filter value)<\/p>\n\n\n\n
“AllowNewAPI” should be set to true then only the above filter condition will work.<\/p>\n\n\n\n
![\"\"](\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-200-1.png?resize=479%2C501&ssl=1\")
Advanced Options<\/figcaption><\/figure><\/div>\n\n\n\n Now comes the important part, Refreshing the chart to bring the latest data based on the query. The chart may be on the home page as a dashboard or based on the selected record the chart should be refreshed as the expected outcome.<\/p>\n\n\n\n
There are two types of data load mode in the chart:<\/p>\n\n\n\n
- Import<\/strong> – It loads all the data to Power BI and then performs the query<\/li>
- Direct Query<\/strong> – It loads the data based on the query<\/li><\/ol>\n\n\n\n
Why all of a sudden the query mode is important? Because there are limitations in the import mode.<\/p>\n\n\n\n
Pro-user – 8 refreshes a day; Premium user – 48 refreshes a day. If it exceeds the limit error will be thrown.<\/p>\n\n\n\n
Import Query – On the refresh button click the following code will be added.<\/p>\n\n\n\n
\/\/GroupID,DatasetID\nPowerBI.RefreshDataset(\"232e2b6d-2e0a-4fd4-8ee9-71f52be1b2d1\",\"fb80d079-a509-42ec-85ba-feee22408842\");\n<\/code><\/pre>\n\n\n\nDirect Query – no need to call the refresh dataset, just need to update the variable and that variable should be passed to the “Reset” property.<\/p>\n\n\n\n
\/\/Here the variable is set to true and then it set to false\nUpdateContext({restVar:true});\nUpdateContext({restVar:false});<\/code><\/pre>\n\n\n\n![\"\"](\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-199-1024x476.png?resize=640%2C298&ssl=1\")
Chart Example<\/figcaption><\/figure><\/div>\n\n\n\n Here are some reference links Filter query<\/a>, Refresh limits<\/a>.<\/p>\n\n\n\n
Please post your queries in the comment section. Happy Building \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"
Power BI is a visualization software available under the umbrella of Power Platform. It accepts data from a wide variety of data sources and the created chart can be integrated with Canvas Apps. “Power BI Tile” is a control available in charts option in the top ribbon bar. We assume that the user already knows Power BI terminologies and already […]<\/p>\n","protected":false},"author":2,"featured_media":1720,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","footnotes":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[6,56,32,5],"tags":[12,9,64,63,65],"class_list":["post-1638","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-canvas-apps","category-powerbi","category-power-platform","category-powerapps","tag-canvas-app","tag-powerapps","tag-powerapps-integration","tag-powerbi","tag-powerbi-integration"],"jetpack_publicize_connections":[],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-199.png?fit=1113%2C517&ssl=1?v=1637949407","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":1204,"url":"https:\/\/365stack.in\/index.php\/2021\/06\/14\/a-complete-guide-for-migration-to-power-platform-know-your-tool\/","url_meta":{"origin":1638,"position":0},"title":"A Complete Guide for Migration to Power Platform: Know your tool","author":"Hemanthkumar Rajan","date":"June 14, 2021","format":false,"excerpt":"Power Platform, It is a consolidation of analytics, design, development, automation and bots. It can be connected to Office 365, Azure, Dynamics 365 and hundreds of other apps to build end-to-end business solutions.","rel":"","context":"In "Power Platform"","block_context":{"text":"Power Platform","link":"https:\/\/365stack.in\/index.php\/category\/power-platform\/"},"img":{"alt_text":"Power Platform","src":"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/06\/powerplatformimage-e1623694447483.png?fit=433%2C260&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1871,"url":"https:\/\/365stack.in\/index.php\/2022\/04\/11\/how-to-create-power-bi-charts\/","url_meta":{"origin":1638,"position":1},"title":"How to create Power BI Charts","author":"Hemanthkumar Rajan","date":"April 11, 2022","format":false,"excerpt":"Power BI is a visualization software available under the umbrella of Power Platform. It accepts data from a wide variety of data sources and the chart can be embedded into other Microsoft products or any Web apps. This post is for beginners who started out their journey in Power BI.\u2026","rel":"","context":"In "Power BI"","block_context":{"text":"Power BI","link":"https:\/\/365stack.in\/index.php\/category\/power-platform\/powerbi\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/12\/Screenshot-289.png?fit=1200%2C639&ssl=1%3Fv%3D1638710879&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":2278,"url":"https:\/\/365stack.in\/index.php\/2021\/12\/28\/how-to-send-json-data-to-canvas-apps\/","url_meta":{"origin":1638,"position":2},"title":"How to send JSON data to Canvas Apps","author":"Premkumar Perumal","date":"December 28, 2021","format":false,"excerpt":"We're going to explain how to send a JSON response from Power Automate to Canvas app and how to convert the response into Collection format in Canvas app. To illustrate, we have explained a small app as example. As First step, create a new Instant flow that can be triggered\u2026","rel":"","context":"In "Canvas Apps"","block_context":{"text":"Canvas Apps","link":"https:\/\/365stack.in\/index.php\/category\/power-platform\/powerapps\/canvas-apps\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/12\/Screenshot-2021-12-28-103100.png?fit=836%2C391&ssl=1%3Fv%3D1640667678&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1456,"url":"https:\/\/365stack.in\/index.php\/2021\/09\/17\/powerapps-print-form-to-pdf\/","url_meta":{"origin":1638,"position":3},"title":"How to Print Scrollable Screen to PDF in PowerApps","author":"Hemanthkumar Rajan","date":"September 17, 2021","format":false,"excerpt":"One of the common requirements in any application is to print the data either to save the form as PDF or print the form. PowerApps provides Print() function to print the screen in a printable format, but the limitation is the screen height cannot be greater than 2164px. If a\u2026","rel":"","context":"In "Canvas Apps"","block_context":{"text":"Canvas Apps","link":"https:\/\/365stack.in\/index.php\/category\/power-platform\/powerapps\/canvas-apps\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2020\/10\/background1.jpg?fit=1200%2C675&ssl=1%3Fv%3D1623349406&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1139,"url":"https:\/\/365stack.in\/index.php\/2021\/06\/09\/how-to-perform-both-filter-and-search-in-gallery-using-power-apps\/","url_meta":{"origin":1638,"position":4},"title":"How To Perform Both Filter And Search In Gallery Using PowerApps","author":"Kanagaraj Neelamegan","date":"June 9, 2021","format":"video","excerpt":"Perform Search and Filter together in Gallery control. https:\/\/youtu.be\/TSj35fiDjqQ","rel":"","context":"In "Canvas Apps"","block_context":{"text":"Canvas Apps","link":"https:\/\/365stack.in\/index.php\/category\/power-platform\/powerapps\/canvas-apps\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/06\/FilterSearch.png?fit=1200%2C541&ssl=1%3Fv%3D1623349368&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1631,"url":"https:\/\/365stack.in\/index.php\/2021\/11\/27\/add-repeating-section-in-powerapps\/","url_meta":{"origin":1638,"position":5},"title":"Add repeating section in PowerApps","author":"Hemanthkumar Rajan","date":"November 27, 2021","format":false,"excerpt":"As we already discussed, Gallery is a multipurpose control in the canvas app. One of the use-cases of gallery is the repeating section, this scenario will be applicable between Parent-Child relationships in Lists or tables and if the form is converted from Nintex, InfoPath (OOTB repeating section control available there)\u2026","rel":"","context":"In "Canvas Apps"","block_context":{"text":"Canvas Apps","link":"https:\/\/365stack.in\/index.php\/category\/power-platform\/powerapps\/canvas-apps\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-197.png?fit=1045%2C267&ssl=1%3Fv%3D1637926841&resize=350%2C200","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/posts\/1638","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/comments?post=1638"}],"version-history":[{"count":8,"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/posts\/1638\/revisions"}],"predecessor-version":[{"id":2449,"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/posts\/1638\/revisions\/2449"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/media\/1720"}],"wp:attachment":[{"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/media?parent=1638"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/categories?post=1638"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/tags?post=1638"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- Direct Query<\/strong> – It loads the data based on the query<\/li><\/ol>\n\n\n\n