Forum Discussion
User lookup during a session
Thank you, KNP ,
My clients are generally large firms or enterprises that can publish secure tables / data for their users in a variety of ways. That data (with names) will be available to them behind their firewall and would be available for the session when they are connected to my published reports. Many of the clients use Power BI in their organizations, but some do not. I do not have any access to these lookup tables (ID -> Proper Name) , so is not available when I publish the report. I could point to a table or location, but only they would have access to it during the runtime viewing. That is why my published reports show ID only. I would like to know if there is a way that Power BI lets a runtime table lookup occur that could convert ID to Proper Name for their viewing.
Without a data refresh happening it would be difficult.
I was thinking you could parameterize the file/path of the table with names which would allow you to have a dummy table for development purposes and your client could change it once deployed, to point at the correct path/file. This doesn't really solve the issue if you need it to work when the report is opened at runtime. You really need the names to be in a direct query source.
The only way I can think of that might work is to incorporate PowerAutomate to handle the refresh interactively from the report.
You may be right about the "bridge too far".