cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ells
Helper II
Helper II

How do I get the name of the file into the Query in Power BI Designer

Hi,

so new to Power BI but have used Excel and SSIS to blast workbooks into Office 365 sites.

 

I need to create a standard Excel or Power BI Designer Template that can create a query based on either the current user or the name of the file.

 

Eacxh person will need their own unique data set and I though the easiest thing was to link it to the File name (based on their name) or onto their user ID.

 

They must only see their data and nobbody elses. Never doe this in the Power BI Designer before so all help appreciated and if you can expand to include directory names as well that would be usefull.

Many Thanks

E

1 ACCEPTED SOLUTION

ells,

Couple things here. 

1) Building a tabular model and using that in the Designer (desktop) only works 1/2 way right now. You can connect to the Tabular model, but the relationships that you've built aren't recognized. This will apparently be resolved in the GA release on the 24th.

http://blogs.msdn.com/b/powerbi/archive/2015/07/10/announcing-power-bi-general-availability-coming-j...

2) You don't need to download the AS connector for use in the Designer.

3) Are you planning on leveraging the Designer as the DataSet on the PowerBI site?

4) There is an AS Tabular direct connection from the PowerBI Site, and there is no additional modeling work needed.

    - You can build your reports and dashboards on site

   - Word of caution as it relates to the "roles" in SSAS. It only applies to the individual who is creating the reports / sharing dashboards. So if user A sees everything in the model, and shares a dashboard with User B (who should only see "x") - User B will see everything that User A does.

I haven't tested this out with the designer, but I would imagine the roles apply if the actual PIBX is passed around. But that really isn't a solution of "sharing a report"

  - The Direct Connect to AS from the site does require the AS Connector Gateway.

 

There are a ton of different options, so any additional details would help steer you in the right direction...


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

2 REPLIES 2

ells,

Couple things here. 

1) Building a tabular model and using that in the Designer (desktop) only works 1/2 way right now. You can connect to the Tabular model, but the relationships that you've built aren't recognized. This will apparently be resolved in the GA release on the 24th.

http://blogs.msdn.com/b/powerbi/archive/2015/07/10/announcing-power-bi-general-availability-coming-j...

2) You don't need to download the AS connector for use in the Designer.

3) Are you planning on leveraging the Designer as the DataSet on the PowerBI site?

4) There is an AS Tabular direct connection from the PowerBI Site, and there is no additional modeling work needed.

    - You can build your reports and dashboards on site

   - Word of caution as it relates to the "roles" in SSAS. It only applies to the individual who is creating the reports / sharing dashboards. So if user A sees everything in the model, and shares a dashboard with User B (who should only see "x") - User B will see everything that User A does.

I haven't tested this out with the designer, but I would imagine the roles apply if the actual PIBX is passed around. But that really isn't a solution of "sharing a report"

  - The Direct Connect to AS from the site does require the AS Connector Gateway.

 

There are a ton of different options, so any additional details would help steer you in the right direction...


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

ashishrj
Power Participant
Power Participant

You can try importing data into SSAS Tabular model and create roles. Later you can pull data into Power BI Designer using SSAS tabular data modeling

Roles (SSAS Tabular)

SQL Server Analysis Services Tabular data in Power BI

Configure a Power BI Analysis Services Connector

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.