Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

In a MAC Machine - using power bi service

Hello,   I am trying to add New columns to my source data in Excel, Refresh the report created in Power Bi service. However, the newly added columns doesn't show up in my data in power bi service i...
Need Help
  • v-sdhruv's avatar
    v-sdhruv
    1 year ago

    Hi Anonymous ,

    This issue does not seem specific to Mac. Power BI Service behaves the same across platforms because it's browser-based. The problem typically arises from how Power BI handles schema changes in the source file, especially Excel.

    1.Try to look for steps like Promote headers, changed type, or any column-specific transformations.

    Update or remove steps that reference old column structures.

    2. If your Excel file changed from a sheet to a table or vice versa, Power BI may fail to locate the correct data.

    3.  If you're connected to a dataset in Power BI Service and not directly to the Excel file, you may not be able to transform the data. Try to re-import the Excel file from scratch in Power BI Desktop and publish again

    Thank you Sahir_Maharaj  for your valuable insight and prompt response on the query. 

    Hope this helps!
    If the response has addressed your query, please accept it as a solution  so that other members can easily find it.
    Thank You

v-sdhruv's avatar
v-sdhruv
Community Support
1 year ago

Hi Anonymous ,
Just wanted to check if you had the opportunity to review the solutions provided?
If any of the response/s has addressed your query, please accept it as a solution  so other members can easily find it.
Thank You