Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi everyone
I have decided to rebuild some of my data silo reports using a sharepoint folder to open up autorefresh dataset options etc.
I have brought in my first look up table of job numbers with locations and other info.
When I load the table with the job number at the start the location works. I loaded a slicer for location as a test and I get numerical values from a text column? I am at a loss how this is happening? There are no relationships inthis model yet as report 2020_02 is the first look up table I will use.
Solved! Go to Solution.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsRegards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsI have been working with the original table for 6 months. There are 4 locations and they are all letters, no numerical values in there at all.
i checked its format and it was set to "ABC/123". I changed it to text and it errors (see later comment on spurious data I found while writing this)
I am getting lots of errors when "combining" the files on inserting them. Subject to other forum threads, but I am getting the issue witht the Feb 2020 update "The active item should be a query" during pull it in, but the data does then appear. May be related, may be not.
I may have spotted something. As I am building up the model I added 2020_03 files to the sharepoint folder. I had used a text filter to "contains 2020_02". this did not exclude the new files so added spurious rubbish to the column. I am going to bin this one. Put all the csv files of 12 or so reports in there before I create the inserts. Putting new stuff in the sharepoint stuffs it up
as I managed to do the same again I think yes. I need to have individual folders on sharepoint for my data as I am still building up the number of fileneames I need. Or I need to do all my data files first so that no new ones come in to my combined query. Will close the thread now. Thanks for the help.
Yeah, that's weird, I got nothing...
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |