Hi v-lili6-msft ,
Thanks for the reply.
I tried the steps you mentioned (dataset refresh followed by report refresh) but still couldn't see the updated schema in Power BI Service.
I'm attaching the PBIX file link here for you to replicate/explore.
This pbix file has one table in DirectQuery Mode, and one card visual that just shows the count of rows in the table.
The pbix file is created and saved when the table has only 3 columns in it. After that, I added two more columns to the table.
Opened this file in Power BI Desktop before and after adding the columns and here is what it looked like.
- Power BI Desktop before refresh (original pbix file -> with 3 columns)
- Power BI Desktop afteer refresh (original pbix file reflecting 2 added columns)
- Power BI Web Service after refresh (not reflecting additional 2 columns, after dataset is also refreshed)
Could you please try replicating the same with the above attached pbix file at your end? Maybe if you observe the same thing and can have us connected to the power bi engineering for this issue.
If you require credentials to connect, please can you send me an email to my registered ID and I should be able to share that with you. The credentials will be valid for 24 hours.
Thanks very much for the help.