Forum Discussion

dheslin's avatar
dheslin
Regular Visitor
4 years ago

Power Query not identifying all rows from excel unless I resort in excel and save???

I have two excel files that are generated from an Alteryx workflow that obtains information from SAP. These two files are the only data source for a Power BI build. The refresh of these files happens...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi dheslin ,

 

Where do you want to achieve automatic refresh? Schedule refresh can be turned on on Power BI Service, refer to Configure scheduled refresh - Power BI | Microsoft Docs.

Automatic page refresh is enabled in Power BI Desktop, but there are a few things to keep in mind when you use automatic page refresh in Power BI Desktop or in the Power BI service:

  • Import storage mode is not supported for automatic page refresh. You can only refresh manually.
  • Composite models that have at least one DirectQuery data source are supported.
  • You can only have one change detection measure per dataset.
  • There can only be a maximum of 10 models with change detection measure in a Power BI tenant.

 

Best Regards,

Stephen Tao

 

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