Share
Report
82Hello all,
I have troubleshot this extensively with no success.
Following @Shanescows video https://www.youtube.com/watch?v=Boh_d8ybhVM ,I am attempting to integrate a PowerBI tile into my app and filter based on a gallery selection.
To filter my Matrix (pivot) table viz in PBI, my TileURL looks like this:
"https://app.powerbi.com/embed?dashboardId=13c82ee3-cbd0-4a89-9ef4-26830c0c8364&tileId=e99e4744-7324-49b1-b11c-a0d68e04612e&config=eyJjbHVzdGVyVXJsIjoiaHR0cHM6Ly9XQUJJLVVTLUVBU1QtQS1QUklNQVJZLXJlZGlyZWN0LmFuYWx5c2lzLndpbmRvd3MubmV0IiwiZW1iZWRGZWF0dXJlcyI6eyJtb2Rlcm5FbWJlZCI6ZmFsc2V9fQ%3d%3d&$filter=ProjectList/PIDText eq '461000'"
However, no matter the change I make in the URL, the table will not filter. I am sure that the following guidelines have been followed.
1) I am attempting to filter a Text field. My number (461000) is from an numeric ID column in PBI that I duplicate and then convert to Text (thus, PIDText).
2) My visualization is pinned to a dashboard, not the whole report. See this solution: https://powerusers.microsoft.com/t5/Building-Power-Apps/Power-BI-tile-filter-not-working/m-p/434129#M128621
3) I have confirmed that this filter does work in the format above in the PowerBI Service URL, just not in the PowerApps TileURL.
Some nuances/notes
1) SharePoint list is my data source for PowerBI report
2) The column in SharePoint is actually my "Title" column (but I have renamed it in Sharepoint to PID"
3) In Shane's vid, he does not use a $ after the & in his appended filter query. However all documentation shows that that needs to be a part of the filter parameter you pass via the URL. I have tried all of my combinations both ways (with and without $). Clearly it worked for Shane without it, not sure if it was added after he made his video.
4) As mentioned above, my PID column is stored as an integer in the PBI model, then using Transform Data I duplicate the column and convert it to Text.
5) I am only using a single filter and using 'eq'.
6) None of my tables or columns have a space.
7) My PIDText column is actually in a lookup table that has a many-to-many relationship (that's future Me's problem, because it isn't actually many-to-many, PBI just thinks that it is, anyways I digress....). While PIDText is a field in the visualization I am trying to filter, I have tried converting it to Text in both my data table, where it serves as the foreign key, and in the Lookup Table where (where it is the primary key). I wouldn't think it would matter considering that PBI is designed to filter in that manner.
😎 I'm ready to rip my hair out.
Any help would be greatly appreciated.
Kindly,
Caz
All responses (
Answers (
