I have a report that has many different tables, all saved on SP through a Teams site. I've been having many issues with it:
1) sometimes when applying new power query changes I get an error message for the queries but it disappears so quickly I cannot even see what the issue is to troubleshoot it. When this happens I have to revert back to an older version and start my changes over again
2) it will not refresh the tables by the refresh in the PBIX or on Power BI Service, I have to manually refresh each table 1 x 1 in the modeling section. I have Enable Load & Include in Report check for all of these tables
3) I have one table that will now not refresh and pull in the new data at all. It has updates from this morning that I can see in the excel file, the file is synced to the SP site, it shows the correct update time in power query but the actual values are NOT updating.
this has all been incredibly frustrating and I'm not sure what else to do at this point. I don't want to have to start from scratch
