Forum Discussion
Helper IPower Automate - "Run a query against a dataset" - missing columns from Power BI semantic model
Hi PetterR,
Handle Empty Columns in DAX:
One way to address this is to handle BLANK() values directly in your DAX query, so columns with empty rows are not omitted. You can use:
IF(ISBLANK([YourColumn]), "No Data", [YourColumn])This ensures the column is included in the output, even if it contains no data.
Ensure All Columns Are Included in Create CSV Table:
Check the settings in the "Create CSV table" action and make sure the "Include headers" option is enabled. This will help ensure all column headers are present in the CSV, even for columns with empty or sparse data.
Use a Placeholder for Empty Columns:
If columns are being skipped due to empty values, setting a placeholder like "No Data" in your DAX query for empty rows may help keep those columns in the output.
Test with Excel File Export:
Alternatively, you can try exporting the data to an Excel file using the "Create an Excel file" action, which may handle empty columns more reliably.
Thank you.
Helper IThank you for the quick reply.
According to my understanding you propose 4 (actually 3 different) options to address the issue, of which adapting the settings in the Power Automate action would be the most efficient in terms of not requiring adaptation of the data transformation ("No data" if cell is empty).
I've checked the action "Create CSV Table" in my flow and i couldn't find the setting "Include headers", please check screenshot of action and code:
Could you please give a hint, where the setting that you propose can be found?
And please don't tell the answer you shared was AI generated 😉
Hi PetterR ,
Thank you for reaching out to the Microsoft Fabric Community.
You'll find experts in Microsoft Fabric and Power BI on this forum. However, for queries specifically related to Power Platform (such as Power Automate), I recommend posting your question in the dedicated Power Platform Community Forum for more targeted assistance.If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Thankyou.
Hi PetterR ,
Have you had a chance to open a thread in the Power Platform Community to get more insights on your issue?
So as to get best possible help and more targeted guidanceHi PetterR,
Were you able to create a post in the Power Platform Community? It could help you get more specific advice and a wider range of suggestions for your issue.
Thank you.