data modeling
7 TopicsPower BI Image URLs from Tenant-Secured SharePoint – Intermittent Rendering Issues
Hi everyone, I’m experiencing ongoing issues with displaying image URLs in Power BI reports and apps, and I’m struggling to identify a reliable solution. Context We store employee/user headshots as image URLs in a user lookup table within the models. These images are used across multiple reports for UI elements such as: Logged-in user icons Employee of the Month visuals Leaderboards and other internal dashboards The images are hosted in a company SharePoint folder maintained by our Marketing team. All employees have view permissions to this SharePoint location (not anonymous access). Issue 1 – Power BI Service / Teams When opening reports in Power BI Service or via Teams, some images load correctly while others appear as broken image links. If I manually open the SharePoint image folder in my browser (authenticating via our tenant) and then refresh the report, the images display correctly. However, this only persists temporarily, typically by the next day the images are broken again. This makes me suspect an authentication, cookie, or caching issue rather than an issue with the URLs themselves. Issue 2 – Digital Signage We also surface these reports via a digital signage solution on screens around multiple offices. In this scenario, none of the SharePoint-hosted images render, they consistently show as broken links. Interestingly, the images display correctly in the digital signage platform’s preview, but fail once pushed to the physical screens. My assumption here is that the signage devices do not have the required authentication context (cookies / tokens) to access tenant-secured SharePoint images. Question Has anyone encountered similar behaviour when using SharePoint-hosted image URLs in Power BI? Is there a known or recommended approach for handling image authentication/caching issues like this? Are there better-practice alternatives for hosting images used in Power BI (especially for digital signage scenarios)? Would a different hosting method (e.g. public blob storage, CDN, base64 encoding, etc.) be more appropriate? Any guidance or suggestions would be greatly appreciated, as I’ve struggled to find clear documentation or examples covering this use case. Thanks in advance.1.3KViews0likes6CommentsBug with Power BI Desktop January 2024 - Save SSAS-Live Connection Report as .pbit looses Measures
Power BI Desktop (Optimized for Power BI Report Server - January 2024), Version 2.124.1960.0, looses all Report Level Measures when saving the Report as .pbit File. This behaviour exists only for Reports with a Live Connection to SQL Server Analysis Services and the Measures are added as Report Level Measure inside the Power BI Report.Solved2.9KViews7likes6CommentsAzure DataBricks to Power BI connectivity
Hi team, I am facing this error when i am trying to import data from Azure DataBricks to Power BI. The cluster is active only not terminated while trying to import. I am using UserName and Password as Credentials. It is throwing the following error "ODBC: ERROR [HY000] [Microsoft][ThriftExtension] (14) Unexpected response from server during a HTTP connection: SSL_connect: certificate verify failed." Any update or resolution provided is highly appreciated. Unable to fix the issue from 1 month. Kindly help in fixing it Thank you in advance PFA1.1KViews0likes2CommentsProblem with uploading of report from the Report Server after last update
Following moving to a centralised model on a workspace rather than an indivudal model being built in each individual report/dashboard we have looked to update our existing reports to all work from this one dataset in PowerBI. After recreating all the reports/dashboards with the new connection in PowerBI services, we have published them with the same name but found them to duplicate the report rather than overwriter (see screen shot below). Can someone explain how to stop this occuring, so that the publish overwrites the existing rather than creating another version? Thanks604Views0likes0CommentsBubble and Filled maps Location field must be named "Location" or data will not render
I am using Power BI Report Server August 2017 Preview with Power BI Desktop RS June 2017 GA. On both Filled and Bubble maps, the calculated column value placed in the Location well field must be named "Location" or the data will not render on the map regardless of the field value, including order, structure (comma-delimited or not), and data categorization of any individual fields. The name of the field placed in the Location well should not matter, only the contents of the field. Reproducible example: Calculated column with [City, State, "USA"] named "Location" renders data on both bubble and filled maps. Rename the column to "LocationCity" and all rendered data disappears. Rename the column back to "Location" and all data reappears. Location well containing calculated column "Location": Location column renamed to "LocationCity":Solved3.6KViews0likes4CommentsLive data confusion
Hi, I see that the August preview supports non-SSAS data sources but not for DirectQuery. So I assume that the only way to get live data is to use SSAS. My question is: can we connect to SSAS Tabluar and have SSAS setup for DirectQuery and thus get live data into Power BI Reporting Services reports? Thanks, Chris1.3KViews0likes1Comment