New column from Dataverse is not visible in Power BI

[Anonymous]

I have a Solution in which I'm hosting Power App and a dataverse table. 

I imported this table in Power BI using dataverse direct query. There are no filters.

After publishing the report in different solution than where table is, I modified the dataverse table and added new columns. 

 These new columns are not visible in PBI now. I refreshed the semantic model, and they do not appear. If I click on Explore this data, these column are not visible here. I downloded the report to edit in Desktop, refresh there and, same thing. No new columns.

I have PowerApp integrated in this BI and it;'s working fine with new columns. I can submit the data through it for new columns just fine.

How can I see those newly added column here?

Thanks!

[Anonymous]

Thank you for your response @PijushRoy . I found the mistake I was making. Please see the solution.

[Anonymous · Accepted solution]

Found out the mistake: 

I was downloading the Report. When we download and open report in PBI desktop, it does not allow to play with datasource i.e. semantic model.

Right way is to download the semantic model. This semantic model also contains the report and you get ability to modify datasource. 

This is completely non-intiutive and there is no way to one will know they have to download Semantic model and not the report. Both the file looks exactly the same, behave exactly same when published, but they vary greatly in their capabilities depending on where you downloded it from. 

Screw Microsoft 

[PijushRoy]

Hi @Anonymous 

Please check in Power BI Desktop, only considering the previously loaded column./

For testing purposes, please insert the data again in Power Query as a new table and check whether columns are available or not.