Refresh errors after normalizing flat files coming from a folder in Power BI

[chriscorpion786]

Hi All,
I am using the folder option to append multiple files coming from a folder. In Power Query, I have normalized the tables into fact and dimension tables. The problem is when I refresh the queries from Power BI Desktop, I get multiple errors as in the screen shot. I am not sure why these errors occur, if I go to Power Query editor and refresh there and then come back into Power BI Desktop the refresh works.
Any one faced such a problem and if any one has the solution, would appreciate the help.

 

[Matt Allington]

Go into file, options and settings, options. There are 2 settings for privacy settings, one under global and one under the current workbook. Change the current workbook to “ignore” at a minimum. There is some small risk of exposing confidential data to the web under unlikely conditions that I have never seen in my 10+ years working with PQ, but personally I wouldn’t worry about it and just make this change.

 

[chriscorpion786]

Go into file, options and settings, options. There are 2 settings for privacy settings, one under global and one under the current workbook. Change the current workbook to “ignore” at a minimum. There is some small risk of exposing confidential data to the web under unlikely conditions that I have never seen in my 10+ years working with PQ, but personally I wouldn’t worry about it and just make this change.

Thanks Matt, I have tried it on my other Power BI file where I was having the same issue and it worked. I wonder what does the privacy settings have to do with combining files and the normalization procedure, but it is working. I will try the same on my other Power BI file later in evening and will let you know if that too is solved in the same way....

 

[chriscorpion786]

Glad to say Matt, the other file also worked. Amazing...I had sleepless nights trying to find a solution.
What is the idea behind it, could you explain please...
Thank you.