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

Data Sources with Data Gateway

Hi everyone,

 

I create reports on my laptop and saves those reports on a network share from our company. The data sources for those reports are also on the shared folder, but when I connect to those files Power BI uses x:\foldername\filename.

Our on premise data gateway is installed on a dedicated server which also has access to these files, but trhough \\servername\foldername\filename. When I publish a report it will use x:\ path and I can't add that same path to the gateway. But when I use the path \\servername\.. I can't connect to the files in Power BI Desktop...

 

How can I make this work?

 

The connection with \\servername\ in de gateway is fine. But when I publish the Power BI desktop with the \\servername\ path, Power BI Service still sees it as x:\.

1 ACCEPTED SOLUTION

Accepted Solutions
TimHellegers Regular Visitor
Regular Visitor

Re: Data Sources with Data Gateway

So it seemed to be that IT denied my access to those folders. They gave me access to the folder and I was able to use the UNC Path.

2 REPLIES 2
Highlighted
Super User
Super User

Re: Data Sources with Data Gateway

Hi @TimHellegers,

I'd like to recommend using parameters. You can create a parameter PathToYouStorage which you set in Power Query Editor to your x:\foo\bar\ and then you append the file name, see the screenshot.

 

Capture.PNG

Next, you load your file using the parameter like this:

let
    Source = Csv.Document(File.Contents(PathToYourFolder & "fileName.csv"),[Delimiter=",", Encoding=1252])
in
    Source

Then you publish you pbix to Power BI Service and change the parameter in the setting of your dataset.

Capture2.PNG

 

More to this topic: Deep Dive into Query Parameters and Power BI Templates

 

TimHellegers Regular Visitor
Regular Visitor

Re: Data Sources with Data Gateway

So it seemed to be that IT denied my access to those folders. They gave me access to the folder and I was able to use the UNC Path.

Helpful resources

Announcements
Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 259 members 2,643 guests
Please welcome our newest community members: