topic Export MS Access Reports to Power BI in Report Server https://community.fabric.microsoft.com/t5/Report-Server/Export-MS-Access-Reports-to-Power-BI/m-p/2790843#M25977 <P>Hi,</P><P>&nbsp;</P><P>Got a number of MS Access applications that are "linked tabled" to a single MS SQL database.<BR /><BR />I want to amalgamate them all into a single application (Power Apps, .net desktop app, asp.net web?)<BR />but first looking to strip out all the functionality and logic out of the appliactions, so they are basically as much of just front end as possible.<BR />This includes all the reports built into them.<BR /><BR />Is there a way of export the reports and their design, to Power BI, so I don't have to re-write them from scratch, which is not my thing and is going take ages and be a world of pain.<BR /><BR />Regards,<BR /><BR />Keith.</P> Sat, 24 Sep 2022 04:49:00 GMT Anonymous 2022-09-24T04:49:00Z Export MS Access Reports to Power BI https://community.fabric.microsoft.com/t5/Report-Server/Export-MS-Access-Reports-to-Power-BI/m-p/2790843#M25977 <P>Hi,</P><P>&nbsp;</P><P>Got a number of MS Access applications that are "linked tabled" to a single MS SQL database.<BR /><BR />I want to amalgamate them all into a single application (Power Apps, .net desktop app, asp.net web?)<BR />but first looking to strip out all the functionality and logic out of the appliactions, so they are basically as much of just front end as possible.<BR />This includes all the reports built into them.<BR /><BR />Is there a way of export the reports and their design, to Power BI, so I don't have to re-write them from scratch, which is not my thing and is going take ages and be a world of pain.<BR /><BR />Regards,<BR /><BR />Keith.</P> Sat, 24 Sep 2022 04:49:00 GMT https://community.fabric.microsoft.com/t5/Report-Server/Export-MS-Access-Reports-to-Power-BI/m-p/2790843#M25977 Anonymous 2022-09-24T04:49:00Z Re: Export MS Access Reports to Power BI https://community.fabric.microsoft.com/t5/Report-Server/Export-MS-Access-Reports-to-Power-BI/m-p/2792407#M26012 <P>If you can, cut out the middleman and remove the Access database from the equation.&nbsp; Connect Power BI directly to the SQL Server database .</P> Sun, 25 Sep 2022 01:19:07 GMT https://community.fabric.microsoft.com/t5/Report-Server/Export-MS-Access-Reports-to-Power-BI/m-p/2792407#M26012 lbendlin 2022-09-25T01:19:07Z