Every time that I refresh my data in Power BI Desktop, I get an error message that it failed. This is the error message that I get:
I have researched online how to fix this error and I found a solution that said to load the data into one query and then do nothing else, and then create another query to connect to that query instead of connecting to a data source. An example of this is:
My Loading Query titled 'LIST-Detail Entry':
The first few steps of the Query I am transforming:
I have also found another solution in changing the data privacy settings, and I have done that so that the data can refresh without problems and neither of those two solutions have solved the error message that I am getting.
Unfortunately I cannot share my .pbix file, so if there is any screenshots of anything that I can provide to assist in a solution just let me know!