UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Powerbi & Access, Access 2016    
 
   
lord_kaiser
post Dec 8 2017, 01:44 AM
Post#1



Posts: 110
Joined: 8-August 17
From: Australia


Hi Everyone,

Just wanted to know if someone can point me in the right direction with turtorials resources of integrating MS Access with PowerBI?

Looking to create reports and a dashboard?

Thanks

--------------------
Regards,
lord_kaiser

Build it and they will come!!
Go to the top of the page
 
MadPiet
post Dec 8 2017, 02:35 AM
Post#2



Posts: 2,426
Joined: 27-February 09



There's not really anything to it.

You connect to Access from PowerBI, then import whatever you want into PowerBI. You can grab data from queries and/or tables, and filter those down (both rows and columns) in PoweBI.

Look around on www.powerbi.com and see what you find there. There are tutorials all about it. Also there are tutorials on YouTube as well.
Go to the top of the page
 
GroverParkGeorge
post Dec 8 2017, 08:48 AM
Post#3


UA Admin
Posts: 33,009
Joined: 20-June 02
From: Newcastle, WA


Power BI can consume data from a large variety of sources.
Attached File  PowerBIDataSources.png ( 29.78K )Number of downloads: 4

So, you can easily integrate your data from Access.

You can publish your Power BI visuals to your Power BI server and use the link to the URL in your Access forms to launch and display them.

Up until recently, you could display the PBI visuals in a browser control in an Access form, but the November update to PowerBI broke that capability. Their response to my inquiries was, basically, tell Access to fix their Web Browser Control. I was very disappointed.

Nonetheless, the combination is a very powerful one, IMO.


--------------------
Go to the top of the page
 
ChiliDog
post Dec 8 2017, 11:16 AM
Post#4



Posts: 187
Joined: 9-September 11



GPG thanks very much for this information. I've been trying to sort out Access / Power BI integration and this helps clear the fog.

Can I post my own question here. I've been tasked with, and I don't think this is possible...integrating PBI *into* Access. Meaning, we have an Access frontend/SQL server backend, and we want to be able to launch PBI *from Access*, and I suppose link to SQL Server tables (but connections must not be exposed). I think this is not doable, correct ? And the client will never go for any cloud-based solution...

I'm starting to conclude the closest we could come is to launch Excel, with a pre-defined Power Query template to ETL the SQL server data in a form the user can understand, and use Excel reporting tools.

If anyone has any clues I'd be grateful. Thanks.


Go to the top of the page
 
GroverParkGeorge
post Dec 8 2017, 11:49 AM
Post#5


UA Admin
Posts: 33,009
Joined: 20-June 02
From: Newcastle, WA


Well, you can open any PBI file from within Access. In turn, that PowerBI file can display the charts and graphs you want to display. or you can use a line like this to display the visuals in your browser:

Application.FollowHyperlink "https://app.powerbi.com/view?r=YourCustomPowerBIIDStringGoesHere"

--------------------
Go to the top of the page
 
lord_kaiser
post Dec 8 2017, 11:06 PM
Post#6



Posts: 110
Joined: 8-August 17
From: Australia


Thanks for the suggestion everyone.

I'll start looking inot this further.

--------------------
Regards,
lord_kaiser

Build it and they will come!!
Go to the top of the page
 
MadPiet
post Dec 9 2017, 07:03 AM
Post#7



Posts: 2,426
Joined: 27-February 09



You don't need Access for this at all. You can call stored procedures directly from PowerBI Desktop. You could just put all the objects users need to do their analysis in a single schema in SQL Server, grant users execute rights to them, and then you'd be all set.
Go to the top of the page
 
MadPiet
post Dec 9 2017, 07:13 AM
Post#8



Posts: 2,426
Joined: 27-February 09



If you're brand new to PowerBI/DAX/PowerPivot, look up chandoo's stuff on YouTube, so you can get your head around some of the stuff in PowerBI. The hardest part is learning DAX - for that, buy Rob Collie & Avi Singh's book - it's on powerpivotpro.com. As for "connecting Access and PowerBI Desktop", well, there isn't much there, because PowerBI Desktop is pretty much the Analysis Services engine with a bunch of connectors, and then the visuals. PBID can use almost anything as a source, including Access... but it works best with star schemas. (That's what it "inherits" from coming from SSAS).

If you read Rob & Avi's book, they walk you through getting data, creating relationships, building measures using DAX, etc. And you can download all the files they use from Rob's website.
Go to the top of the page
 
GroverParkGeorge
post Dec 9 2017, 09:05 AM
Post#9


UA Admin
Posts: 33,009
Joined: 20-June 02
From: Newcastle, WA


The question was, as I recall, can you integrate PBI with Access, not can you bypass Access and go straight to PBI.

The point is, I would imagine, whether someone using Access as their database for an application--both data store and interface--can take advantage of the superior visual presentations possible with PBI.

That said, of course, PBI certainly has a lot of, well, power, beyond that starting point.

--------------------
Go to the top of the page
 
cocoflipper
post Jan 26 2018, 07:24 PM
Post#10



Posts: 1,144
Joined: 11-August 03
From: Denver - CO


Hi George,

Do you know if there is any movement on the "PBI visuals in a browser control within an Access form", that broke with the November PBI update? It would be nice to utilize the web browser control with PBI. You also later in this post mention that you can open any PBI file from within Access, but if it is not with the web browser control, how do you do it?

--------------------
"Effort only fully releases its reward after a person refuses to quit."
- Napolean Hill, author
Go to the top of the page
 
GroverParkGeorge
post Jan 27 2018, 10:02 AM
Post#11


UA Admin
Posts: 33,009
Joined: 20-June 02
From: Newcastle, WA


Sorry, somehow I didn't get a notice of a reply.

I just use a hyperlink to open the PBI visual in a new browser window. Nothing fancy.

I have a sense that the PowerBI people could care less about breaking the web browser control in Access. I have given up any hope of getting progress on this.

On the other hand, the annual MS MVP Summit is coming up in March and I'll be face-to-face with the people involved, so maybe it'll be harder to ignore me. woohoo.gif

--------------------
Go to the top of the page
 
cocoflipper
post Jan 27 2018, 06:15 PM
Post#12



Posts: 1,144
Joined: 11-August 03
From: Denver - CO


Go get 'em George. Have to keep Access relevant.

--------------------
"Effort only fully releases its reward after a person refuses to quit."
- Napolean Hill, author
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    17th July 2018 - 02:47 AM