cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Fra
Regular Visitor

Power BI Service connection to Azure File Share

Hi,

I set up a domain in Azure including two Virtual Machines (VM) in this domain, one acting as a domain admin and a another where I installed SQL Server (SS) and Analysis Services (SSAS). In my activity, this domain represents my customer domain, so that I can keep getting trained deploying SSAS databases there from my "consultant" laptop - which is out of that domain - and see issues and so forth.

 

I successfully developed Visual Studio solutions deploying them from my laptop (which, again, is outside the domain) to the SSAS instance installed on the SS-installed Azure VM and then successfully imported the deployed SSAS solution as a data source in Power BI Desktop from my laptop and finally deployed (published) a report to Power BI.com, setting the refresh. All OK (difficult, but OK).

 

Now, in another scenario, I have an issue.

 

In the same Azure domain, I mounted (mapped) on the SQL-Server-mounted Azure VM a drive (Z:) connected to a newly created Azure file share: everything works fine - I can successfully open this "drive" from that VM and see the files, copy, delete and so on.

 

I also successfully mounted (mapped) a "drive" connected to the same Azure File share on my personal "consultant" laptop, which is, again, out of Azure. I can successfully open this "drive" from my laptop and see the files, copy, delete and so on. 

 

To make this work I had to indicated the path to the Azure file share, the user and the password that Azure gave me when creating the File Share.

 

The reason for this second scenario is to simulate that my customer has no SS nor SSAS but has the data sources somewhere in a machine in their domain (\\domain-name\path).  So I have to develop a Power BI project that takes the files on that domain machines an input, after working on Power BI Desktop on my laptop (out of the domain, again). In the real world they will set up my a VPN, but I wanted to simulate things on my own to develop, understand and so on without the effort of a VPN.

 

So: in Power BI Desktop on my laptop (out of Azure) I was able, using parameters, to connect (import) alternatively  local files on my laptop (development data source) and then to switch to import the data from the remote files (production data sources) in the Azure file share (mapped into a drive as explained above).

 

I then published the report to PowerBI.com, and started adding the datasources (dev on my laptop and prod on Azure File Share) to a gateway in order to set up a refresh.

 

Here comes Bad surprise: while it was successfull to connect the gateway to the dev source on my laptop, I was NOT able to connect to the same data source in Azure File Share from PowerBI.com. Again: no problem from Power BI Desktop, but problem only in PowerBI.com.

 

So my question is:

 

is it possible to connect from PowerBI.com (NOT from Power BI Desktop, for which I alrerady succeeded) to a file (for example an excel file) that is in an Azure File Share to use it as a data source to register on a on-premises Data Gateway for refresh?

 

I hope my post is clear, sorry for the length, I wanted to explain the purpose as that might help understading how to help me.

 

Thanks

3 REPLIES 3
v-shex-msft
Community Support
Community Support

HI @Fra ,

AFAIK, current you can't direct get data from SQL/SSAS datasource at power bi service side. After these connectors are available on desktops side, power bi service has disabled them on service side.

You need to create report on desktop side and publish it to use on power bi service side.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Thanks

 

I was referring to Azure File Share, please read again the post and answer me on this subject

 

Thanks again

v-shex-msft
Community Support
Community Support

HI @Fra ,

//I was referring to Azure File Share, please read again the post and answer me on this subject

I think your device has configure proxy so that you can direct connect azure data source. 
For this scenario, I'd like to suggest you to enable gateway proxy setting, then you can connect to specific azure sql datasource based on proxy setting.

Configure proxy settings for the on-premises data gateway

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.