Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Regular Visitor

Problem to publish to web, maybe an issue with license

I have created 2 boards in the PB service: I want to use the first (prueba1) as a data repository for a second (prueba2). The data originates from a SQL server query. prueba2 has a directQuery query to the PowerBi dataset of prueba1 . It seems the configuration is correct. Within the PowerBI service, prueba2 works correctly, you can see the data and interact with it. Many attempts are made to publish a website (public), when creating the embed code it does not allow it and does not throw any error or mention. Apparently it's going to be a privacy issue or permission to use data outside of the PB platform (in SQL) via a second board. The question is how to configure boards to have access to that board as a unique repository
and be able to create the public web report of prueba2 or if there is a limitation if the user used in the service in a PRO license?
Thank you for your answer.

Board Prueba1 Captura de pantalla 2023-05-05 095329.png

Board Prueba2
Captura de pantalla 2023-05-05 095400.png

Prueba1 on PB service, SQL Query, external shared activated
board prueba1 on PB serviceboard prueba1 on PB service
prueba1 SQL query with sql  user credentialsprueba1 SQL query with sql user credentials

Prueba2 on PB service, DirectQuery to prueba1 with PBservice user credentials (Cuenta de Microsoft)
board prueba2 on PB serviceboard prueba2 on PB service
prueba2 DQ query to second PB service board  PB user credentialsprueba2 DQ query to second PB service board PB user credentials

Publishing intent, there's no message, error or warning.
trying to publish  prueba2 on web, there´s no message , warning or errortrying to publish prueba2 on web, there´s no message , warning or error



Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors