Forum Discussion

ustas55's avatar
ustas55
Icon for Helper II rankHelper II
4 years ago

Missing columns in Excel PowerPivot

Good Day,   We are observing/experiencing an interesting behavior of MS Excel when sourcing data from the PBI model published to the service. We have PBI model created/sourced from SQL Server, all...
Need Help
v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
4 years ago

Hi, ustas55 

 

Please look at your permissions on the dataset and check if this is relevant?

 

Please refer to the following documents to see if they help you with your problem.

Analyze in Excel for Power BI - Power BI | Microsoft Docs

Create a PivotTable from Power BI datasets (microsoft.com)

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • ustas55's avatar
    ustas55
    Icon for Helper II rankHelper II
    4 years ago

    Good Day,

    Thank you for your comment. The dataset is configured correctly and I'm able to access it and view data.

    The issue I'm facing is that number of columns in the Excel Pivot Table is different (less) than in the filed list in the service. I did doublecheck, and all columns are set to be visible within dataset.

     

    Best Regards,

    Sam