User Profile
skygold16
Helper II
Joined 4 years ago
User Widgets
Contributions
Re: Power BI Embedded semantic model
Thanks Akash_Varuna Anonymous. I do not need RLS in the model. This report is going to be open for Public consumption. Report will be showing data at the aggregated level however I want to make sure that there is not way anyone can access underlying data that is at non aggregated level. Also, when you say securing your model properly, what do you refer to?1.4KViews0likes1CommentPower BI Embedded semantic model
Hi everyone, We are publishing Power BI report to the public interface and hence we are considering to go with power bi embedded. However, we have some concerns regarding the import of granular data into the dashboard. Even though the visuals will display aggregated and grouped data. The dashboard will be made publicly accessible, and authentication will be handled via a service principal account, meaning users won’t need to provide credentials. With this setup, I would like to know if there’s any way for end users to access the granular dataset or access the semantic model in anyways like XMLA? Of cournse, we want to avoid any risk that user can access to the granular data level. Regards,Solved1.6KViews0likes9CommentsRe: How to disable some preview LIMIT 1000 queries on a refresh?
By the look of this issue, it looks like you have used native query while creating a connection with databricks. You need to check if you are filtering only 1000 rows when connecting. check you native query view. Or check your databricks query in the advance editor of Power Query.3.7KViews0likes1CommentRe: Overwrite .pbix with .pbip while maintaining user access + links?
Each artefact in Power BI workspace is store using a specific guid. Replacing the file with the same name, doesn't change the ID however if there is change in the file name, Power BI will treat that as a new artefact. Hence it is always adviced to share the report using Power BI Apps. I understand it hard to update each of the user with the new link, however idle approach to this issue would be to create an app and send the comms to all the people having access to the workspace explaining new features of Power BI Apps.661Views1like0CommentsRe: Offline SQL Connection in automatic data refresh but single refresh is possible
Hi nludwig When you say you are able to refresh manually, do you mean on the desktop? if yes, then your DB admin need to whitelist the incoming request coming from the gateway machine. In my experience, whenever admin build new machine and if you are not able to refresh it from the services, most of the time it is firewall and proxy routing related issue. You need to talk to your internal networking team to understand the network traffic flowing from Power BI service to your onprem data source.740Views0likes1CommentRe: Power BI Pro - MY SQL Link
Hello TristanWood99 , Where is your SQL server located? Do you know if there is a connectivity established from the Power BI service to SQL server? Did you try setting up data connection on the gateway? Regarding your SSH issue, you can try using the port number in your connection string when you define your SQL server name for ex: SQLserver.domain.xxx:5558.501Views0likes0CommentsRe: Dashboards sending incorrect dates
Hi beanboy , I have noticed that the datetime value refers to the UTC time when in the service. You can possibly use a card and check what datevalue your relative datetime column is generating in the Power BI service and potentially that could be an issue.546Views0likes0Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.