Excel Power Query Refresh

If I understand you correctly, you are using powerbi to get the data from the database, but you want to acces it through Excel. You are not using the PowerBI for reporting or dashboards.

If that is the case, skip PowerBI and make a seperate DB Connection spreadsheet instead. Then connect the user's spreadsheet(s) to this new spreadsheet.

If you place the DB Connect spreadsheet on a sharepoint site of a network folder, you can connect the user's spreadsheet to the DB connect spreadsheet.

I have been using this approach for performace reason, putting all complicated PowerQuery in the DB Connect spreadheet and connect user's spreadsheet to the DB Connect sheet. 2 advantages: Only 1 place to maintain the complex PowerQuery and speed.

Did I answer your question? Then please (also) mark my post as a solution and make it easier to find for others having a similar problem.
Remember: You can mark multiple answers as a solution...
If I helped you, please click on the Thumbs Up to give Kudos.

Hi lherbert501 ,

Please refer below links.

Publish a paginated report to the Power BI service - Power BI | Microsoft Learn

Export Power BI paginated reports - Power BI | Microsoft Learn

Paginated reports in Power BI: FAQ - Power BI | Microsoft Learn

Export Power BI paginated report to Microsoft Excel (Power BI Report Builder) - Power BI | Microsoft Learn

Develop Paginated Report using Power BI Report Bui... - Microsoft Fabric Community

Solved: How to export more than 150000 rows from Power BI ... - Microsoft Fabric Community

I hope this information helps. Please do let us know if you have any further queries.

Regards,

Dinesh