I have conveted and Excek power pivot model to power BI

[Anonymous]

I have converted an Excel power pivot model to Power BI. When I go analyze excel to create a pivot table I realize the data has not been refreshed only shows until the period May 21. I need the data to be refreshed as of October 2021. I also need to create new measures. What is the best way to do that? I have done many courses but I need some guidance I feel a bit lost right now. Thanks in advance for your help

[v-yangliu-msft · Accepted solution]

Hi  @Anonymous ,

Did you use the Import connection mode to import to power bi, or use Analyze in Excel.

About using measure, it can only be created in Power bi desktop. Regarding refreshing data, you can directly use scheduled refresh to refresh the data for the former, and you need to refresh the data in Excel for the latter.

Best Regards,

Liu Yang

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

[Anonymous]

Please send me links or sites where I can see the steps ot tutorials