Forum Discussion
Post ProdigyExcel 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
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
Super UserIf 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.
Post Prodigy
Is there any documentation anywhere on this method?
I'm interested to try it but not quite sure I understand it fully.
Thanks
- PwerQueryKees
No documentation as such. In Excel you can get data from a SharePoint folder. And after selecting the file you are after, open it and access it's data. It al depends a bit of how your data is structured. I am sure you can find videos on accessin Excel files on SharePoint or on a network drive.
Kees Stolker
A big fan of Power Query and Excel
- PwerQueryKees
For example https://youtu.be/-XE7HEZbQiY?si=2STX9o7FxoDVoANX