Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
Solved! Go to 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.
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...
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.
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...
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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
89 | |
87 | |
81 | |
64 | |
49 |
User | Count |
---|---|
123 | |
109 | |
88 | |
68 | |
67 |