BookMarks Functionality from Power BI to Power Apps

[Balakrishnan_J]

Hi Power BI Community Members,

I got an requirement to transfer the Bookmarks functionality from Power BI to Power Apps.

I can able to achieve this only for predefined Bookmarks but I want like once I embed power BI report into Power Apps I want to dynamically change the bookmarks (Like applying year 2025 and region USA. Both can be changed as per user selection)

Is this possible? Need your support.

Regards,
Balakrishnan_J

[v-sdhruv]

Hi @Balakrishnan_J ,

Since we didnt hear back, we would be closing this thread.
If you need any assistance, feel free to reach out by creating a new post.

Thank you for using Microsoft Community Forum

[v-sdhruv]

Hi @Balakrishnan_J ,

Just wanted to check if you got a chance to review the suggestions provided and whether that helped you resolve your query?

[v-sdhruv]

Hi @Balakrishnan_J ,

Just wanted to check if you got a chance to review the suggestions provided and whether that helped you resolve your query?

Thank You @DataNinja777  and @Ritaf1983  for sharing your inputs to the query.

[Ritaf1983]

Hi @Balakrishnan_J 

You're encountering a known limitation of composite models:
It is not supported to create calculated columns or calculated tables that refer to remote tables via DirectQuery. When mixing imported data with DirectQuery sources, any calculation that references a remote table (even indirectly) will trigger a semantic model warning, and can block refresh after publication.

To resolve this, you’ll need to restructure the model:

• Move any required logic to the Import side of the model, or

• Join the necessary data at the data source level before it reaches Power BI, ensuring the model doesn’t rely on cross-source calculations.

Also, to clarify:
If there's a problem with refresh, the Power BI Service will always raise a clear error message. It won’t silently skip refresh. So while the warning is there to prevent future failures, an actual error will be triggered if refresh fails after publication.

One more note — based on your steps, it’s possible that metadata from the original calculated column still exists in the model’s schema, even if you deleted the column visually. This could happen if:

• The column with the same name was reintroduced, even if in a different way.

• The semantic model still holds traces of the original DAX logic.

To eliminate this possibility:

• Try saving your report under a new name and publishing it again.

• Use Model View to verify there are no hidden or inactive calculated columns or tables (for example, those with “disable load” or hidden status).

• If you're using a semantic model published to a workspace, you might want to connect with Tabular Editor or XMLA endpoint to inspect the model schema directly.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[DataNinja777 · Accepted solution]

Hi @Balakrishnan_J ,

You can achieve this outcome not by changing the Power BI bookmarks themselves, but by dynamically applying URL filters to the embedded Power BI report directly from Power Apps. This method allows you to filter the report based on user selections in your app, which provides the same experience as a dynamic bookmark.

First, you'll need to set up your app. Start by getting the base embed URL for your report from the Power BI Service by navigating to File > Embed report > Website or portal. Copy this URL. Then, in your Power Apps screen, add the user input controls you need, such as dropdowns for selecting the year and region. Finally, insert the Power BI tile from the Insert > Charts menu.

The key to this functionality lies in dynamically setting the TileUrl property of the Power BI tile you added. You will write a formula that combines your base URL with a filter query string. This string will be constructed using the values selected in your dropdown controls. The filter syntax uses the OData format, which looks like &$filter=TableName/ColumnName eq 'Value'.

"https://app.powerbi.com/reportEmbed?reportId=...&autoAuth=true&filterPaneEnabled=false" &
"&$filter=SalesData/Year eq " & ddYear.Selected.Value &
" and SalesData/Region eq '" & ddRegion.Selected.Value & "'"

This formula concatenates several pieces to build the final URL. It starts with your base embed URL, then appends the &$filter= parameter to begin the query. It specifies the table and column to filter (e.g., SalesData/Year). Notice that the value for the year, which is a number, is taken directly from the year dropdown (ddYear.Selected.Value). The and operator is used to add a second condition. For the region, which is a text value, its value from the region dropdown (ddRegion.Selected.Value) must be enclosed in single quotes ' '.

Be careful with a few important details. The table and column names in the formula (SalesData/Year, etc.) must exactly match the names in your Power BI data model. If a name has a space, you must enclose it in single quotes in the URL string, like 'Sales Data'/'Product Name'. Also, always remember the syntax for data types: no quotes for numbers and single quotes for text values. Getting these details correct is essential for the dynamic filter to work.

Best regards,