Forum Discussion
Power Query and Power BI
Hiya KarenFingerhut , can you give us more details about the audit report? Is it a Microsoft created report or is it a custom audit report? If it's a custom audit report is the report built soley using the Power BI REST API?
It could be that a dataset was created in Excel and is being utilized in Power BI. Is your user saying that they're not using the dataset that they created in Excel in Power BI? If a user creates a dataset in Excel saves the file and connects to that file in Power BI it would show as CreateDataSet.
Assuming it's built only with the Power BI REST API then it would have to be built in Power BI either by using Power BI Desktop and publishing or starting from the Power BI Service creating a new dataset and using Power Query Online. If you're using a custom report then you should be able to create a table to see the user, activity, creation date, dataset name, and workspace. If you return results with that then that tells you that the dataset was created in Power BI and is being stored in a Power BI workspace.
If you're at least a member of the workspace you can go to datasets and click the View option and change it to Lineage. That will show you if there is a report connected to the dataset.
Hope this helps!
Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up! ?
Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.
Hiya KarenFingerhut , can you give us more details about the audit report? Is it a Microsoft created report or is it a custom audit report? If it's a custom audit report is the report built soley using the Power BI REST API?
It could be that a dataset was created in Excel and is being utilized in Power BI. Is your user saying that they're not using the dataset that they created in Excel in Power BI? If a user creates a dataset in Excel saves the file and connects to that file in Power BI it would show as CreateDataSet.
Assuming it's built only with the Power BI REST API then it would have to be built in Power BI either by using Power BI Desktop and publishing or starting from the Power BI Service creating a new dataset and using Power Query Online. If you're using a custom report then you should be able to create a table to see the user, activity, creation date, dataset name, and workspace. If you return results with that then that tells you that the dataset was created in Power BI and is being stored in a Power BI workspace.
If you're at least a member of the workspace you can go to datasets and click the View option and change it to Lineage. That will show you if there is a report connected to the dataset.
Hope this helps!
Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up! ?
Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.
HI Watsky
Thank you for your reply. Its really helped. Appreciate the detail you've gone in to. I've definitely learnt something today
Many thanks
Kind regards
Karen