Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
I am using the following PowerBI template in PowerBI Desktop:
https://docs.microsoft.com/en-us/microsoftteams/cqd-pstn-report
I want to be able to create a dashboard and publish this to the cloud somewhere for our support teams to be able to access. I have looked at publishing it to the PowerBI service but I am not sure if that is going to satisfy my requirement or not? I was hoping there would be a web link to the report which could be displayed by our support teams on their monitoring screens.
When I publish it to the PowerBI service I receive an error in regard to credentials for the data source being missing. I assume thats becuase when I published the report the creds were not exported. The data source is the Microsoft Call Quality Dashboard.
Any help would be gratreful
Many thanks
Solved! Go to Solution.
Hey @PowerBiNoobie1 ,
the credentials that you enter opening the template in Power BI are not stored in the pbix (for a good reason), instead these credentials are stored on your machine in the windows credentials store (don't be afraid, this is a good place).
After publishing the report to the Power BI Service there is a dataset and a report, unfortunately the credentials are missing.
For this reason you have to enter the credentials for the data source once again. This makes sure that the man in the middle who might intercept the pbix as it is in transit, does not have the credentials.
This article describes how to configure a scheduled refresh for your dataset:
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh
Here you will find the section "Data source credentials", enter the credentials once again and you are ready to go (most of the time ;-))
Hopefully, this provides what you need to tackle your challenge.
Regards,
Tom
Hi @PowerBiNoobie1 ,
I think the question was answered by my two SuperUser colleagues.
Here is a very good white paper when it comes to providing reports.
Planning a Power BI Enterprise Deployment
This updated technical whitepaper outlines considerations and best practices for a well-performing and secure organizational Power BI deployment.
Hi @PowerBiNoobie1 ,
I think the question was answered by my two SuperUser colleagues.
Here is a very good white paper when it comes to providing reports.
Planning a Power BI Enterprise Deployment
This updated technical whitepaper outlines considerations and best practices for a well-performing and secure organizational Power BI deployment.
Hey @PowerBiNoobie1 ,
the credentials that you enter opening the template in Power BI are not stored in the pbix (for a good reason), instead these credentials are stored on your machine in the windows credentials store (don't be afraid, this is a good place).
After publishing the report to the Power BI Service there is a dataset and a report, unfortunately the credentials are missing.
For this reason you have to enter the credentials for the data source once again. This makes sure that the man in the middle who might intercept the pbix as it is in transit, does not have the credentials.
This article describes how to configure a scheduled refresh for your dataset:
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh
Here you will find the section "Data source credentials", enter the credentials once again and you are ready to go (most of the time ;-))
Hopefully, this provides what you need to tackle your challenge.
Regards,
Tom
Hi there
Just to add with what @TomMartens has said
Below are the steps where you will need to re-enter your credentials again once uploaded to the Power BI Service.
Now go back to the report and it should be working.