Hello Bi Community, I know what I am trying to accomplish is possible and has been done before. However, I am unable to find an answer specific to my solution requirements. &nbs...
I've got a series of date excel files where there are a few misc rows of data at the top, then has the dates listed horizonally, one per column (see picture below). I'd like to write a query to combi...
I have the longest files of this type of code: MSH|^~\&|ECWExport|1256895402|TXImmTrac|TxDSHS|20230525082503.125-0500||VXU^V04^VXU_V04|3051312345678082603|P|2.5.1|||ER|AL|||||Z22^CDCPHIN...
Dear all, i noticed that my Power BI desktop doesnt have dynamic data type. I saw alot of youtube tutorial that used dynamic data type to make their chart more interactive. Do anyone know why ...
Good morning all, I hope you are well. I'm trying to work out the most effective way to tackle a data set I have been asked to produce visuals from. The excel sheet consists of separate she...
Hi Power BI community I have a table with five columns 1. Index: An index column 2. Assignment: A Number column that shows diffrent assignment. (In this example we will j...
Hi Please does anyone know how to resolve the above. I'm getting Expression.Error: The column " " of the table wasn't found. However, the column is present in my data source and I can a...
I recently added a new file to a SharePoint folder and am having issues connecting to it. I'd like to just update my query to point to the new file but it is saying that it can't find the file....