Hi great explaination....bt can you also provide a video on azure analysis service tabular model auto refresh using REST or functions...it will be helpful
Excellent video Patrick. Thanks! If I have several external facing customers that I were to add as guest users in this manner, would they be able to access my report using a Power BI free account?
Not necessarily. You can only share dashboards to free users if the workspace is backed by Premium. Although, if the report is within an App workspace, you cannot add external users to the app workspace due to a limitation with Office 365 Unified groups.
Worth noting under Membership you can only search under the tenant you are a member of, if your a guest or CSP admin you will need to create a member account to search users and groups.
Great video Patrick. One small thing to add, It is best to use Universal authentication when logging into SSMS. This will work with all kinds of logins including MSA accounts.
Patrick, thanks this was extremely useful and informational. I have a question...which is easiest to implement, granting external clients access to data using Azure AS? Or Power BI embedded in Share Point Online?
They are different things. One is data and the other is visualization. That being said, I would personally think setting up the Power BI web part for SharePoint Online is pretty easy. I just get the URL from a report in the service and slap that into the web part. Then I'm done. Not much to it. The Azure AS item is a little more involved, but still not bad. You have to navigate the Azure portal though.
Thanks Patrick. Any way we can leverage AD groups and leverage those groups in the AS roles, instead of adding individual accounts to a role? Thanks again for all the work you and Adam do.
Great stuff, Patrick. Question: does the carat that you clicked on to change the date to Year only show up for certain cases? I have a slicer that uses a Calculated Column for the date and that carat doesn't show up in the Slicer visual.
I have a local SSAS Tabular Server and I am trying to connect to it through live connection from Power BI Service, any insight will be highly appreciated.
Hi Patrick, How can i give external users access to my published report where the data is accessed through a gateway to an on-premises Analysis Server. they receive error, need permission to data source. also setup Map user name. thanks
Is this only allowed for azure analysis services servers? We have Office 365 and therefore are using AAD with an on-premises SQL Server. We are currently using a data gateway to connect the Power BI Service to our database and have pro accounts but not all of our users are on the same domain. Can we use azure b2b in the same way to give outside users access to our Power BI content via App Workspaces. If I try to update the App Workspace with new users it gives and error saying they are not validated.
Yes this is specific to Azure Analysis Services. Azure B2B is coming for Apps. This was highlighted in the initial blog post for Apps. Stay tuned on that! :) I don't know if that will also work for app workspaces though.
This is great! It really adds to the capabilties of AzureAS and opens up a lot of doors with people not part of your domain. Keep it coming!
Thanks Alex! Agreed that this opens up a ton of options. Thanks for watching!
Hi great explaination....bt can you also provide a video on azure analysis service tabular model auto refresh using REST or functions...it will be helpful
Excellent video Patrick. Thanks!
If I have several external facing customers that I were to add as guest users in this manner, would they be able to access my report using a Power BI free account?
Not necessarily. You can only share dashboards to free users if the workspace is backed by Premium. Although, if the report is within an App workspace, you cannot add external users to the app workspace due to a limitation with Office 365 Unified groups.
Worth noting under Membership you can only search under the tenant you are a member of, if your a guest or CSP admin you will need to create a member account to search users and groups.
Great video Patrick. One small thing to add, It is best to use Universal authentication when logging into SSMS. This will work with all kinds of logins including MSA accounts.
Thanks, Josh! Great call out!
Patrick, thanks this was extremely useful and informational. I have a question...which is easiest to implement, granting external clients access to data using Azure AS? Or Power BI embedded in Share Point Online?
They are different things. One is data and the other is visualization. That being said, I would personally think setting up the Power BI web part for SharePoint Online is pretty easy. I just get the URL from a report in the service and slap that into the web part. Then I'm done. Not much to it. The Azure AS item is a little more involved, but still not bad. You have to navigate the Azure portal though.
Thanks Patrick. Any way we can leverage AD groups and leverage those groups in the AS roles, instead of adding individual accounts to a role? Thanks again for all the work you and Adam do.
Great stuff, Patrick. Question: does the carat that you clicked on to change the date to Year only show up for certain cases? I have a slicer that uses a Calculated Column for the date and that carat doesn't show up in the Slicer visual.
I know it does change based on data type. I haven't tried with a calculated column.
I have a local SSAS Tabular Server and I am trying to connect to it through live connection from Power BI Service, any insight will be highly appreciated.
I thought you said at one point that you would show us how to hire the server name later. I missed it. How do you do that?
Hi Patrick, How can i give external users access to my published report where the data is accessed through a gateway to an on-premises Analysis Server. they receive error, need permission to data source. also setup Map user name. thanks
Great video Patrick
Thanks for watching Gilbert!
Great presentation!
Thanks for watching Omar!
I am trying to do this using SSAS 2017 but it does not appear to work? Is there anything I need to be made aware of.
This is specific to Azure Analysis Services.
Does the Azure Analysis service work for Multidimensional model ?
Unfortunately not at this time.
Is this only allowed for azure analysis services servers? We have Office 365 and therefore are using AAD with an on-premises SQL Server. We are currently using a data gateway to connect the Power BI Service to our database and have pro accounts but not all of our users are on the same domain. Can we use azure b2b in the same way to give outside users access to our Power BI content via App Workspaces. If I try to update the App Workspace with new users it gives and error saying they are not validated.
Yes this is specific to Azure Analysis Services. Azure B2B is coming for Apps. This was highlighted in the initial blog post for Apps. Stay tuned on that! :) I don't know if that will also work for app workspaces though.
How can I move my onperm analysis tabular model to an azure analysis server?
Video coming!
GREAT VID MAN U ROCK
Thank you so much! And, thanks for watching!
you save my day !