There have been two new columns added to my source database. I can see the two columns when I view the data via Power Query Editor but I cannot see the two columns in the normal data view.
There have been a number of occasions when new fields have been added to the database and there has never been any problems, they simply just appear when the data is refreshed. Therefore, I'm unsure what is going on this time around.
Thanks in advance for any solution ideas.
Solved! Go to Solution.
I found the issue.
I had uninstalled power bi which I had downloaded through the Windows Store due to it not rescaling to size when I put the window onto a larger screen. I then redownloaded power bi using the advanced download option which resolved this resizing issue. However I'm unable to refresh any reports connected to SharePoint. Just as a test I uninstalled the advanced download and reinstalled the version from the Windows Store and the file refreshed fine and I can now see the two columns I refer to in the original question.
This is very odd.
I found the issue.
I had uninstalled power bi which I had downloaded through the Windows Store due to it not rescaling to size when I put the window onto a larger screen. I then redownloaded power bi using the advanced download option which resolved this resizing issue. However I'm unable to refresh any reports connected to SharePoint. Just as a test I uninstalled the advanced download and reinstalled the version from the Windows Store and the file refreshed fine and I can now see the two columns I refer to in the original question.
This is very odd.
What worked for me: I renamed the new columns in PowerQuery and applied changes. Voila, the new fields appeared in the main view. Then just deleted this step in PowerQuery, new fields remained
@e_j , refresh preview and check, In the new version they are getting added automatically.
Otherwise, add the table again as a new table. Open advance editor using the right click of the table. Copy top part and paste into the old table
refer if needed
How to manage when column is added or removed at source: https://www.youtube.com/watch?v=h0yLtceT0i4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L&index=2
Added a new field to the source and it didn't initally show up in Power BI Server. Refreshing the preview worked for me! Thanks amitchandak!
Unfortunately I'm also have issues refreshing this specifc file. All other power bi files a refreshing fine.
For this file in particular I also have a data source connected from SharePoint which is usually the reason it takes longer. I have left his report refresh for about 3 hours where it shows me the number of rows it has refreshed and then almost gets stuck in that state. Any suggestions for this?
I see that behavior too sometimes but the data are there. You can confirm by filtering on one of the columns and the filtered data will likely show.
FYI on this article/video for a much faster way to pull SharePoint list data (if that is what you are doing).
Get Data From SharePoint Lists … But Fast – Hoosier BI
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi Pat, thanks for taking the time to respond.
When I use the search bar to filter down the field names (see pic) the field itself doesn't even show in there.
Will be sure to check out the link for SharePoint, thanks.
User | Count |
---|---|
143 | |
85 | |
63 | |
62 | |
55 |
User | Count |
---|---|
211 | |
108 | |
88 | |
75 | |
72 |