Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I have a published pbix file connected to an excel sharepoint file.
I have added a new column in my excel spreadsheet.
The new column has not reflected in my dataset.
I have refreshed my dataset multiple times. What is the issue?
Please see screenshots below.
New column - K
Columns in dataset after refresh
Thank you.
Solved! Go to Solution.
Hi @christianadaa ,
Different from the refreshing behavior on the desktop, the published dataset only refreshes the loaded fields and tables. To add new fields, you need to refresh and republish on the desktop.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Hi @christianadaa ,
Different from the refreshing behavior on the desktop, the published dataset only refreshes the loaded fields and tables. To add new fields, you need to refresh and republish on the desktop.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Thank you @v-cgao-msft. Greatly appreciated. This helps. All my data is null in power bi desktop when i download my published file so I am afraid to re-publish before fixing this issue.
I have found the applied step that may be causing this. Please see below. Can you help with this?
Applied step - data is showing up fine in power query
Applied step - all data is 'null' from this step onwards
Hi @christianadaa ,
Not sure, please select a column to filter, is there more than one value? I'm guessing that the values at the top of the table sorted this way are all 'null'.
Best Regards,
Gao
Community Support Team
Thank you for your quick response @v-cgao-msft.
Below is what shows up when applying a filter to the column. It is the same for every column.
It is recommended that you close this thread and open a new one in the Power Query forum, explaining the problem and attaching all the code from the Advanced Editor (taking care to hide private information, such as data source information).
Power Query - Microsoft Power BI Community
Best Regards,
Gao
Community Support Team
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.