User Profile
rtran
Helper I
Joined 6 years ago
User Widgets
Contributions
Error: The column '' of the table wasn't found.
Hi! I'm getting the following "Underlying error message: The column '' of the table wasn't found." when I try to refresh in my workspace after publishing.. However, I have no errors and can load/refresh properly without any issues on my local .pbix file. Any ideas on why this is happening? Thanks!2.4KViews0likes4CommentsPre-filtering nested tables before expanding
Hi! I have an issue where my dataset prior to tranforming is huge. I'm simply trying to filter out the unnecessary data of the nested tables in my odata service prior to expanding the tables. I can't seem to figure out a solution where I can filter on records, while keeping all of the other data/columns.. is this possible? I tried converting the records to a table and it didn't yield the results I wanted because it gave me a table with only two columns, where all of the column headers from the records table turned into rows with the value and dropped all of the other data And is it possible to filter on more than one value in the same column? Thanks!!Solved6.6KViews0likes2CommentsRe: Report Builder Tablix - How to avoid data being expanded
Hi Yuna, That worked for me this time, thank you! I also was able to do something similar with the DAX Query and alter it with finding the sum in the query, but I much prefer your method to mine. Thank you for all your help!4KViews1like0CommentsRe: Report Builder Tablix - How to avoid data being expanded
Hi Yuna, I'm not able to replicate your steps and right clicking does not give me the option to change the data type. Is there a difference between uploading from flat files and files that are using a live data source? Thanks!4.1KViews0likes2CommentsRe: Report Builder Tablix - How to avoid data being expanded
Hi Yuna, Yes, I have. The results are still not aggregated and come in as separate rows. Additionally, the summation value of Hours becomes the total hours of all projects instead of total hours of each corresponding project (ex. total hours of all project vs total hours of project A / B / C separately). Do you have any other ideas? Specifically in regards to fixing it on report builder, since it doesn't seem to be an issue with PBI. Thanks!4.1KViews0likes0Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.