Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
tbauch
Frequent Visitor

Published Visualization not working for all users

Good morning, 

 

I'm wondering what sort of issues would cause one user to receive an error on a table visualization:

tbauch_0-1595861746427.png

And myself, the creator of the published .pbix, to have the visualtions function properly:

tbauch_1-1595861866759.png

I had created this table visualtion using a manually entered tablle of part names and then related the manually created table to our ERP data to bring in the appropriate figures. I made the manual table using Excel and copying and pasting the values using PowerBI's "Enter Data" button in the Power Query editor. This produced a data source that begins:

 

= Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText...

 

I created the table because I was worried about using a local file as a data source in a published .pbix. I had recently run across this issue and assumed that creating a table in the .pbix instead of targeting an Excel file would avoid it. That issue being a local file wasn't accessible with our data gateway which is installed on our company's server and not ony my PC. However, I seem to be having the same problem here even though I was under the impression that baking the table directly into the .pbix file would avoid this. 

 

Any help would be appreciated. The goal being to link the table that's baked into the .pbix file to the visualization that's published to the service though independently of the data gateway. 

 

Thank you, 

 

-Tommy

 

 

1 ACCEPTED SOLUTION
tbauch
Frequent Visitor

Fixed it. User had visualization specific filters in place and was unaware that there could be multi-level filters at play. Visualization filters were not showing up when visualization was not selected. I now know to prompt this when troubleshooting. 

View solution in original post

3 REPLIES 3
lbendlin
Super User
Super User

please show the message behind "see details"

tbauch_0-1595936605043.png

 

tbauch
Frequent Visitor

Fixed it. User had visualization specific filters in place and was unaware that there could be multi-level filters at play. Visualization filters were not showing up when visualization was not selected. I now know to prompt this when troubleshooting. 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors